From: Dennis Cote <[EMAIL PROTECTED]>
> 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
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.
> 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.
3 matches
Mail list logo