It doesn't currently. Currently, you can't use subselects.
Cal
http://www.calevans.com
-----Original Message-----
From: Michael Blood [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 5:12 AM
To: MYSQL
Subject: Another MSSQl to mysql question.
does any one know how mysql can handle an exists query.
for example
select xcolumn from ytable
where exists (select 1 from ztable where ytable.id = ztable.id)
I realize that in this particular example I can rearrange my query but there
are lots of other queries where I find it necessary.
Thanks
Michael Blood
Matraex Technologies
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php