Not Exists -- ?

shawnlui · #1 (**permalink**) 06-24-04, 15:18

SELECT t1.f1 from t1 where not exists (select t2.f1 from t2)

How rewrite the above query without 'exist' or 'in'? In the other word, use only 'Inner' and 'Outer join' because MySQL version does not recognize 'exists' and 'in'?

thanks;

Pat Phelan · #2 (**permalink**) 06-24-04, 16:28

You have to do it "the hard way" when the tool won't support subqueries:

Code:

SELECT t1.f1
   FROM t1
   LEFT OUTER JOIN t2
      ON (t2.f1 = t1.f1)
   WHERE  t2.f1 IS NULL;

-PatP

shawnlui · #3 (**permalink**) 06-24-04, 17:56

Thanks, Pat.

Shawn

Internet Services

Web Development

Digital Marketing

Consumer Tech