Select with dual-field empty

Hi

I havent touched oracle for some time...

I want to do a select from 2 tables, where the connection between the tables are fields, but the row migth not exist

e.g.

select * from a, b where a.code=b.code(+), but like this:

select * from a, b
where a.code1=b.code1(+)
and a.code2=b.code2(+)

the point is that both code1 and 2 has to be there.

Any idea how I can do this?

BR
Sonnich Received on Thu Oct 19 2006 - 11:28:56 CDT