shireenh123 wrote:

> How to delete multiple table in one query ?

Sure:

set term ^ ;
EXECUTE BLOCK AS BEGIN
delete from table1;
delete from table2;
delete from table3;
END^

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================