Jump to content


Photo

NESTED SELECT


  • Please log in to reply
1 reply to this topic

#1 perplexed

perplexed
  • Members
  • Pip
  • Newbie
  • 2 posts

Posted 22 December 2003 - 12:36 PM

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

#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,017 posts

Posted 23 December 2003 - 08:11 PM

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


select f.* from film f inner join filmgenre lON f.filmid = l.filmidwhere l.genreid = 4

If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users