网上找了一圈，没有找到合适的，后来自己试了个语句，居然可以，记录下来
select * from (select count(1) as cgtg from [dbo].[kv_cabinetbushing] a where a.isdel=0 and a.supplierWorkNo='') a, (select count(1) as cth from [dbo].kv_contactbox a where a.isdel=0 and a.supplierWorkNo='')b
标签：count,dbo,结果,列名,kv,SQL,supplierWorkNo,isdel,select From： https://www.cnblogs.com/sharestone/p/17166276.html