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]
-----------------------------------------------------------------------------

Reply via email to