> create view myview as select t1.a a from t1 inner join t2 on t1.a=t2.a; > create table problem as select * from myview;
Change this last line to: create table problem as select a as a from myview; That creates the problem table with just "a" as the field name.