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
Title: Blank
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
