Tango.info sql join
Jump to navigation
Jump to search
Example for JOIN on multiple fields
SELECT tango_tracks.album_tin,tango_tracks.album_side, tango_tracks.track_num , tint, 'durations' FROM `tango_tracks_durations` RIGHT JOIN tango_tracks ON tango_tracks_durations.tint = tango_tracks.album_tin + '-' + tango_tracks.album_side + '-' + tango_tracks.track_num