on 3/20/01 1:20 PM, Bryan Coon at [EMAIL PROTECTED] wrote:
> Sorry for the ambiguity, I was trying to make a really generic select
> statement. I just meant that if 'where a = A.a' has no matches, but 'where
> b = B.b' or 'where c = C.c' does match, the query returns what did match,
> and just returns null where it didnt. I will look at the CASE WHEN...THEN.
How is this not just:
... Where a = A.a or b = B.b or c=C.c ...
Thanks,
Geoff
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
