SQL两表无关联联合查询
有A，B两表，求sql代码 变成 C表
这个是笛卡尔乘积
1.select A.*,B.* from A,B;
2.select A.*,B.* from A join B;
希望对你有帮助...
select * from A union select * from B
select t1.* from a t1 cross join b t2
select * from biao1 a left join biao2 b on a.x=b.x
有A，B两表，求sql代码 变成 C表
这个是笛卡尔乘积
1.select A.*,B.* from A,B;
2.select A.*,B.* from A join B;
希望对你有帮助...
select * from A union select * from B
select t1.* from a t1 cross join b t2
select * from biao1 a left join biao2 b on a.x=b.x