Hi William,

you can use subqueries in FB 1.0 - 1.5

SELECT (select COUNT(*) FROM TBL1) + (SELECT COUNT(*)
FROM TBL2) from rdb$database;

in Firebird 2 I believe you can use derived tables...

select count(*) from (select 1 from tbl1 union select 1 from tbl2);

Regards

Ian Newby