I have a SQL Query that looks like this...
SELECT released_title
FROM finishedtrack ft
WHERE ft.originates_from
IN (SELECT originates_from
FROM groupedon
WHERE album_id = (SELECT album_id
FROM Twenty_People_Info));
What I want to do is display a field called sequence from the groupedon table next to the released_title column (they are related by their originates_from value).
What my results should look like is the numbers 1-10 with a song name next to each however, the only thing I have been able to achieve is a list of song names in blocks of 10 with random numbers between 1 and 10 next to them (I attempted this by doing SELECT released_title, sequence FROM finishedtrack ft, groupedon go etc. which is obviously wrong).
Does anybody know how to get what I want (I'm not sure if I've explained my problem too well =P) ?
Thanks in advance for any help, I'll try to clarify anything you need if you don't understand what I'm getting at,
Tom
SELECT released_title
FROM finishedtrack ft
WHERE ft.originates_from
IN (SELECT originates_from
FROM groupedon
WHERE album_id = (SELECT album_id
FROM Twenty_People_Info));
What I want to do is display a field called sequence from the groupedon table next to the released_title column (they are related by their originates_from value).
What my results should look like is the numbers 1-10 with a song name next to each however, the only thing I have been able to achieve is a list of song names in blocks of 10 with random numbers between 1 and 10 next to them (I attempted this by doing SELECT released_title, sequence FROM finishedtrack ft, groupedon go etc. which is obviously wrong).
Does anybody know how to get what I want (I'm not sure if I've explained my problem too well =P) ?
Thanks in advance for any help, I'll try to clarify anything you need if you don't understand what I'm getting at,
Tom