Tango.info sql join
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