Hi,

> Tables T1 and T2 share the field ID (integer).
>
> I want to delete from T1 the rows that are also in T2.
>
> Which is the quickest way to do it in Firebird ?

DELETE FROM T1 WHERE EXISTS (SELECT T2.ID
FROM T2 WHERE T2.ID = T1.ID)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com