1). I found this in MySQL doc:
Derived tables (unnamed views) are now supported!
example: SELECT t1.a FROM t1, (SELECT * FROM t2) t3 WHERE t1.a=t3.a;
Question: Can we do this in FB?
2). How can I simulate the mysql CREATE TABLE table LIKE table in FB?
1) Yes, if you use development branch of Firebird (2.0)
2) In Firebird 1.5 you can write a stored procedure that will do this taking table names as parameters