[ http://issues.apache.org/jira/browse/DERBY-64?page=comments#action_12443918 ] Bryan Pendleton commented on DERBY-64: --------------------------------------
Thanks for the clarification. I agree, that would be a useful feature to have. > 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
