On 7/27/05, Stephan Szabo <sszabo@xxxxxxxxxxxxxxxxxxxxx> wrote: > > I think the where t2.column_id is null where column_id is the joining > column makes this a form of not exists, so maybe: > > DELETE FROM t1 WHERE NOT EXISTS (SELECT 1 FROM t2 WHERE t2.column_id = > t1.columnid); > > This looks good. Thanks. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
