Newbie: delete from multiple tables?

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 - 08:59:29 CDT