Hopefully this is not too lame a question...
In oracle, I can do this:
select a, b, c from A, B, C where a = A.a (+) and b = B.b (+) and c = C.c;
What is the equivalent in MySQL? The (+) allows that 'where' statement to
be kind of optional (I think). Basically I want to do a select on multiple
tables and if one of the 'where' statements doesn't match anything, the
query still returns values for other statements that did (e.g. if a = A.a is
not true, but b = B.b is, I want to return B.b).
Thanks!
---------------------------------------------------------------------
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
