Hello,

Is there any way we could create a table in Firebird using the query?

Ex:-

create table temptable

as

select * from tempquerytable t1, tempquery t2 where t1.slno = t2.slno;

this creates a table  temptable with the structure of both t1&t2

Thanks and Regards