select * from a,b,c 这样就行了一般情况会有一些限制条件那你就加上去 比如select * from a,b,c where a.a = b.b and a.d = c.c这样的
create table table_name as select table1.col,table2.col,table3.col from table1,table2,table3 where XXXX
