Re: HELP w/ Delete Query ot Oracle 7.3

Bruce Hutfless wrote:
>
> Can anyone tell me what I'm doing wrong?
>
> delete from TMP
> where (select FIELD from TMP where FIELD in (select FIELD in TMP)
> intersect (select FIELD in TMP2));
>
> Technical discussion, assume to tables with identical fields, and I wish to
> delete all records in Table1 where a field in Table1 is equal to a field in
> Table2.
>
> My question is this query properly structured to do this, or how should I
> change it?

Use a subquery and EXISTS

-- 
____________________________________
Oleg Dimerman (olegd_at_oeonline.com)