Tango.info sql join: Difference between revisions
Jump to navigation
Jump to search
(Created page with " Example for JOIN on multiple fields <pre> SELECT tango_tracks.album_tin,tango_tracks.album_side, tango_tracks.track_num , tint, 'durations' FROM `tango_tracks_durations` RIGHT ...") |
m (moved tango.info sql join to Tango.info sql join) |
(No difference)
| |
Revision as of 2013-06-13T02:15:38
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