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"
Quotes and all. How bizarre is that? Am I doing something wrong? (The
only way around this that I've found is to change the select to
select
A.col_1 as col_1,
B.col_2 as col_2
It seems to me sqlite should strip off the alias qualifier and create
the table as
col_1,
col_2
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.
