NESTED SELECT

[perplexed]

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

[Barand]

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