Try that:

select field_1 from table_1
where not exists (select distinct field_1 from table_2 where table_1.field_1 = table_1.field1)


Hope that helps,

clio_usa - OCP 8/8i/9i DBA

Visit our Web Site