List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 23 1999 2:25am
Subject:Re: MYSQL QUERY HELP
View as plain text  
On Wed, 1999-09-22 21:41:42 -0400, Bob Kline wrote:
> No, I don't think so.  You've dropped part of the relevant portion of
> the original post, but as I recall he needed to eliminate values which
> showed up in any row for which there was a match with a specified value
> (which is why he says above that he would like it to return only 02 and
> 03, but not 01).  Off the top of my head I think the only way to get
> what the original poster wanted is a SELECT ... WHERE NOT EXISTS (SELECT
> ...) - which we can't do yet in MySQL.  But it's on the to-do list.

Well, as I said - I didn't understand what he really wanted ... :)

But to your last point:

  SELECT ... WHERE NOT EXISTS (SELECT ...)

in most cases can be simulated by

  SELECT ... FROM a LEFT JOIN b ON ...
  WHERE b.xyz IS NULL

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
MYSQL QUERY HELPMathieu Levesque22 Sep
  • Re: MYSQL QUERY HELPMartin Ramsch23 Sep
    • Re: MYSQL QUERY HELPBob Kline23 Sep
      • Re: MYSQL QUERY HELPMartin Ramsch23 Sep