using not exist

[josephi]

I want to rewrite this query with not exists.

select field_1 from table_1
where fields_1 not in (select distinct field_1 from table_2)
Thanks

[clio_usa]

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

[pando]

I guess it's a typo

where table_1.field_1 = table_2.field1

[clio_usa]

It's. Why they always give us so short lunch breaks ???

Thanks for the correction. I will double check the code, before posting it next time.


Hope that helps,

clio_usa - OCP 8/8i/9i DBA

Visit our Web Site