如： 第一个查询语句为：select * from a 第二个查询语句为：select * from b 则并合这两个语句的语句是否为：select * from (select * from a,select * from b)??? 这样好像不对。如果两表的结构相同的话 select * from a union all select * from b 横向left join 纵向 union all SQL code: select * from a left join b on a.id=b.id
select * from a union all select * from b
如果两表字段,类型相同. select * from a union all select * from b
如果两表字段,类型不相同. 更改类型和名称. 例如:
select id , name ... from a union all select cast(bid as int) , bname as name ... from b
或者是:
select a.* , b.* from a , b where a.关键字 = b.关键字 select a.* , b.* from a left join b on a.关键字 = b.关键字
