Jump to content

Archived

This topic is now archived and is closed to further replies.

perplexed

NESTED SELECT

Recommended Posts

hello I have the following query

 


select * from film f WHERE f.filmid = (SELECT l.filmid FROM filmgenre l, genre g WHERE g.genreid=l.genreid AND g.genreid=4 );

 

And with the love of christmas cannot get it to work. Can anyone help?

Or suggest if I can link this with join command.

 

Thankyou for looking

Share this post


Link to post
Share on other sites

I don\'t know your structure but it looks as though you want

 

 

select f.* from film f inner join filmgenre l

ON f.filmid = l.filmid

where l.genreid = 4

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.