MySQL Forums
Forum List  »  Newbie

IN and EXISTS ...
Posted by: bab shah
Date: August 06, 2004 08:44AM

i can't anderstand it ...

i am testing mysql version 4.0.20

a select like

"select * from tab1 where tab1.col1 in (select tab2.col1 from tab2)"

doesn't work !


in manual

there are subqueries with IN and EXISITS and it seems to be supported by mysql ..

thanks a lot


Options: ReplyQuote

Written By
IN and EXISTS ...
August 06, 2004 08:44AM
August 06, 2004 09:06AM

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.