[jira] Commented: (DERBY-64) Create a table with a query

["Bryan Pendleton (JIRA)" <de...@db.apache.org>]

    [ http://issues.apache.org/jira/browse/DERBY-64?page=comments#action_12443861 ] 
            
Bryan Pendleton commented on DERBY-64:
--------------------------------------

Derby does support
   INSERT INTO t SELECT ... FROM other_t;
For example you can do:
  INSERT INTO t1 (a, b) SELECT x, y from t2 where x > 17;

Is this an acceptable solution to your problem?

> Create a table with a query
> ---------------------------
>
>                 Key: DERBY-64
>                 URL: http://issues.apache.org/jira/browse/DERBY-64
>             Project: Derby
>          Issue Type: New Feature
>          Components: SQL
>            Reporter: Christian d'Heureuse
>
> I suggest to implement a SQL statement to create and fill a table with a query, without having to write the columns definition.
> e.g.:
>  CREATE TABLE new_table AS SELECT ...;
> or:
>  SELECT ... INTO new_table FROM ...;

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira