Problem with SQL Query using EXISTS

mccmartini · #1 (**permalink**) 03-19-04, 10:28

Hi, I have a problem with an sql that uses EXISTS, and NOT EXISTS, but it throws me the error:
Syntaxis error or access violation
the query is:
SELECT *
FROM GRVALACD.TCRECLI
WHERE EXISTS
(SELECT *
FROM GRVALACD.TCREDSAL);
does anyone knows which is my error?
Thanks.

Pat Phelan · #2 (**permalink**) 03-19-04, 15:19

Unless you are running the experimental 4.1 release of MySQL, sub-queries aren't supported, so neither is the EXISTS predicate.

You can approximate its behavior using JOIN operations, something like:

PHP Code:


			
SELECT a.*

   FROM GRVALACD.TCRECLI AS a

   JOIN GRVALACD.TCREDSAL AS b

      ON (b.fk = a.pk)

   WHERE  b.column = 'fubar';

Where you join a to b on a key value and you specify whatever other constraints you need in the WHERE clause.

-PatP

Internet Services

Web Development

Digital Marketing

Consumer Tech