Thread: Unnamed views

    #1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Bucharest
    Posts
    72
    Rep Power
    11

    Question Unnamed views


    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?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    15
    Rep Power
    0
    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

IMN logo majestic logo threadwatch logo seochat tools logo