How can I: create table tbl3 as select * from tbl1, tbl2 where tbl1.a = tbl2.a? tbl1 and tbl2 have similar structures, why i get the "duplicate column name" error for such a question. Could someone please give a solution to this. possibly a total different syntax is needed, butwhat?
Thanks in advance