Perfect! Thanks. -----Original Message----- From: Gerry Snyder [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 5:28 PM To: [email protected] Subject: Re: [sqlite] "select into" ?
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] ------------------------------------------------------------------------ ----- -------------------------------------------------------- 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. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
