I'm trying to create a table from a table join. Since each table has a
similar column name. it won't allow me to create the table.
create table tx1 (name1 char(10), employee_code char(1)) engine=myisam;
create table tx2 (name1 char(10), addr char(10)) engine=myisam;
create table tx12 select * from tx1 left join tx2 on tx1.name1=tx2.name1;
Error Code : 1060
Duplicate column name 'name1'
I would have thought MySQL would have named the second tx12.name1 as
"name1_1" so the column name is unique. But instead I get an error.
Is there a way around this because the column list in both tables are dynamic.
TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]