outer joins with composite keys in oracle impossible?

i have two tables a,b with composite keys (c1,c2) and need to perform an outer join.

select *
from a,b
where a.c1=b.c1(+) and
a.c2=b.c2(+)

gives wrong selections.

(a.c1,a.c2)=(b.c1,b.c2) (+) is not accepted..

a.c1||a.c2=b.c1||b.c2(+) is not accepted..

ciao, jan Received on Wed Jan 27 1999 - 11:09:49 CST