dcharno wrote:
>> select types.Track,types.URL from ALBUM inner join (select * from MUSIC
>> where Artist_Id =?) types on ALBUM.AlbumId=types.Album_Id order by
>> ALBUM.YomiAlbumName ;
>
> How does the subquery work in this statement? I thought subqueries
> could only retrieve a single column.
No, that's not true. A sub-query is like any other query. I have
rearranged the query to make it more readable.
select types.Track,types.URL
from ALBUM
inner join (select * from MUSIC where Artist_Id =?) as types
on ALBUM.AlbumId=types.Album_Id
order by ALBUM.YomiAlbumName;
In this case the sub-query is returning the subset of the Music table by
the specified artist. This result table is given the name "types", and
it is joined to the album table.
It is often the case the you use a sub-query to select a single result
value (i.e. one row and one column) for use in a comparison, but there
is no restriction on what they can return.
HTH
Dennis Cote
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
