A syntax error, "duplicate column name". -----Original Message----- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 14, 2007 10:24 AM To: SQLite Subject: [sqlite] Re: another
Anderson, James H (IT) <Jim.Anderson-/PgpppG8B+R7qynMiXIxWgC/[EMAIL PROTECTED]> wrote: > If I run the following sql > > create table table_C as > select > A.col_1, > B.col_2 > > from table_A A, > table_B B > where A.col_3 = B.col_4 > > The table_C is created with the following column names: > > "A.col_1", > "B.col_2" > > It seems to me sqlite should strip off the alias qualifier and create > the table as > > col_1, > col_2 What do you think it should do for something like create table C as select A.col, B.col from A, B; Igor Tandetnik ------------------------------------------------------------------------ ----- 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] -----------------------------------------------------------------------------