Re: Newbie: delete from multiple tables?

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3f16bdd1$0$15034$ed9e5944_at_reading.news.pipex.net...

> SQL> delete t1
> 2 where exists (
> 3 select null from t2
> 4 where t1.id=t2.id
> 5 and t1.col2=t2.col2);
>
> 2 rows deleted.

Excellent - thanks a lot for the help.

Cheers,
Ian Received on Thu Jul 17 2003 - 10:22:13 CDT