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?
How about
CREATE TABLE credDerivEvent AS SELECT DISTINCT CDId, CDEvent FROM
credDerivOrig
HTH,
Gerry
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
