multiple rows sub query 
Author Message
 multiple rows sub query
Hello all! I need your help in writing a single query
that uses a sub query that return multiple rows. Such
as [ select * from songs where songs.song_id = (select
playlistcontents.song_id from playlistcontents where
playlistcontents.playlist_id = 2) ]. Any help would be
greatly appreciated. Thank you!

Quan



Sun, 18 Apr 2004 01:38:41 GMT
 multiple rows sub query

select * from songs where songs.song_id  IN (select
playlistcontents.song_id from playlistcontents where
playlistcontents.playlist_id = 2)

Best regards



Sun, 18 Apr 2004 22:27:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Query using UDF joined to a sub query vs Temp Table to sub Query

2. Does support Sub-query for row filter?...

3. DISTINCT Rows - Sub Queries

4. Update multiple columns from sub-query

5. returning the nth row from a sub query

6. column in multiple rows to multiple columns in one row

7. column in multiple rows to multiple columns in one row

8. Sub queries <> sub tablesl

9. Type, sub-type, and sub-sub-type database design

10. Master Parts/Sub Parts/Sub-Sub Parts

11. Problem querying multiple rows....

12. HELP: Multiple row copies in SQL Query


 
Powered by phpBB® Forum Software