Re: Newbie: delete from multiple tables?

delete table_1
where table_1.field1 in (select table_2.field1 from table_2 )and

        table_1.field2 in (select table_2.field2 from table_2)

Ian McCall wrote:
> Hello.
>
> I'm moving over from Sybase, and am looking for the equivalent syntax to the
> following command:
>
>
> delete table_1
> from table_1, table_2
> where table_1.field1 = table_2.field1
> and table_1.field2 = table_2.field2
>
> In other words delete, only from table_1, anything where field1 and field2
> match a row in table_2.
>
> Any ideas?
>
> Thanks in advance for any information.
>
>
> Cheers,
> Ian
>
>
Received on Thu Jul 17 2003 - 09:12:04 CDT