David Johnson wrote:

>
>>>>Can I use SQL-92 SELECT * INTO NEW_TABLE FROM EXIST_TABLE ???
>>>
>>Wouldn't the syntax then be
>>
>>INSERT INTO NEW_TABLE SELECT * FROM EXIST_TABLE?
>>
>
> The former syntax is correct for creating a new table that exactly
> matches the result of the select statement (a subtle difference, but
> important if you are using this mechanism to change the type of data
> being stored).

Sorry. The first syntax is not standard SQL, however useful.

Regards,


Ann