且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在两列中合并两个SQL查询的结果

更新时间:2022-11-27 15:16:38

Select a.C1-b.C2 as Res
 from
(
Select Count(*) as C1 from Users
Group by Name
) a
join
(
Select Count(*) as C2 from User2
Group by Name
) b ON 1=1 -- or desired condition if existing