Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT theAssetOutletType, count(id) as TotalNoOfAssets FROM dbo.tblLEGAssets where buildingID=1 group by theAssetOutletType
- UNION
- SELECT theAssetOutletType, count(id) as ItemsStillPresent FROM dbo.tblLEGAssets where buildingID=1 and removed<> 0 group by theAssetOutletType
Add Comment
Please, Sign In to add comment