Tango.info sql join: Difference between revisions

From tango.info wiki
Jump to navigation Jump to search
No edit summary
 
Line 3: Line 3:


<pre>
<pre>
SELECT tango_tracks.album_tin,tango_tracks.album_side, tango_tracks.track_num , tint, 'durations'
SELECT ti_track.album_tin,ti_track.album_side, ti_track.track_num , tint, 'durations'
FROM `tango_tracks_durations`
FROM `ti_tracks_durations`
RIGHT JOIN tango_tracks
RIGHT JOIN ti_track
ON tango_tracks_durations.tint = tango_tracks.album_tin + '-' + tango_tracks.album_side + '-' + tango_tracks.track_num
ON ti_track_duration.tint = ti_track.product_tin + '-' + ti_track.product_side + '-' + ti_track.track_num
</pre>
</pre>

Latest revision as of 2015-02-23T06:06:11

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"