Anderson, James H (IT) wrote:
Sybase supports "select into" but sqllite does not seem to. Here's a
sybase example:
select distinct CDId, CDEvent
into credDerivEvent
from credDerivOrig
This query creates the table credDerivEvent. Is there anythin comparable
in sqlite?
Thanks,
jim
--------------------------------------------------------
NOTICE: If received in error, please destroy and notify sender. Sender does not
intend to waive confidentiality or privilege. Use of this email is prohibited
when received in error.
In SQLite you would do this:
CREATE TABLE myTable AS SELECT * FROM myOtherTable;
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
