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
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