Tango.info sql join

From tango.info wiki
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