[ 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
