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 it necessary.
 
Thanks

Michael Blood

Matraex Technologies
[EMAIL PROTECTED]

 

Reply via email to