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.

