perplexed Posted December 22, 2003 Share Posted December 22, 2003 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 Quote Link to comment https://forums.phpfreaks.com/topic/1540-nested-select/ Share on other sites More sharing options...
Barand Posted December 23, 2003 Share Posted December 23, 2003 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 Quote Link to comment https://forums.phpfreaks.com/topic/1540-nested-select/#findComment-5081 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.