At 04:14 AM 12/1/2004, Ian A. Newby wrote:

>in Firebird 2 I believe you can use derived tables...
>
>select count(*) from (select 1 from tbl1 union select 1 from tbl2);

That will, I think, give you the value 2 in all cases.

Regards,


Ann