Small select question...

[Bryan Coon]

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!