On 7/27/05, Stephan Szabo <sszabo@megazone.bigpanda.com> 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.