摘要: 初始的写法是这样的selectt.OfficeSupplyID,ApplyCount -IsNull(SupplyCount,0) as ApplyAccountfrom @TB t left join (select * from Inventory ) i on t.OfficeSupplyID=i.OfficeSupplyIDwhere DomainAccount='lirz'@TB里有十四... 阅读全文