Delete with ANSI Join
830256Jan 11 2011 — edited Dec 14 2011So I’ve decided it time to learn and start using ANSI joins in my queries. I have used the following to successfully view mismatched records in my table.
select table1.*
from table1 left outer join table2
on table1.field1 = table2.field1
where table2.field1 is null
Now I want to delete those records but no matter what I try I get “SQL command not properly ended.” I have searched the topic but cannot figure out what is wrong. This is the query I’m trying.
delete table1
from table1 left outer join table2
on table1.field1 = table2.field1
where table2.field1 is null