Tango.info sql join

From tango.info wiki

Revision as of 2015-02-23T06:06:11 by Tobiasco (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

Example for JOIN on multiple fields

SELECT ti_track.album_tin,ti_track.album_side, ti_track.track_num , tint, 'durations'
FROM `ti_tracks_durations`
RIGHT JOIN ti_track
ON ti_track_duration.tint = ti_track.product_tin + '-' + ti_track.product_side + '-' + ti_track.track_num

Retrieved from "https://tango.info/x/wiki/w/index.php?title=Tango.info_sql_join&oldid=66462"