两张表没有连接条件时(这个看情况用,数据多的时候没有做过验证):
select a.*,b.* from (select ROW_NUMBER() over(order by Id) as rn,* from A) a
left outer join (select ROW_NUMBER() over(order by Id) as rn,* from B) b on a.rn= b.rn
select a.usercode,a.phone,b.roleid,c.rolename from
t_user a
join
t_userrole b
on a.usercode=b.usercode
join
t_role c
on b.roleid=c.id
如果两表查询出来列名都一样,用 UNION ALL 就可以了
select * from 表1
UNION ALL
select * from 表2
select a.*,b.* from (select ROW_NUMBER() over(order by Id) as rn,* from A) a
left outer join (select ROW_NUMBER() over(order by Id) as rn,* from B) b on a.rn= b.rn
select a.usercode,a.phone,b.roleid,c.rolename from
t_user a
join
t_userrole b
on a.usercode=b.usercode
join
t_role c
on b.roleid=c.id
如果两表查询出来列名都一样,用 UNION ALL 就可以了
select * from 表1
UNION ALL
select * from 表2