MySQL Forums
Forum List  »  Newbie

Re: Help me with this query syntax please!
Posted by: Ross Rankin
Date: July 07, 2005 12:54PM

there is nothing in your IN subquery...

You use IN like this:
Select * from table where field in (select field2 from table2);
or
Select * from table where field in (1,2,3,4,5);

Options: ReplyQuote


Subject
Written By
Posted
Re: Help me with this query syntax please!
July 07, 2005 12:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.