Outer join?

[techuser]

I have table1 and table2

table1:
field1
field2
field3

table2:
field4
field5
field6

what I need as a result is to find all rows from table 1 not found at table 2 being field2=field5

I appreciate your help. Thanx in advanced, Marcelo.

[chazzy]

you would use a select that compares the two tables.


select field1, field2, field3 from table1 where field2 not in (select field5 from table2);