Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
SELECT tblUsers.*, q.AssetCount FROM tblUsers LEFT JOIN ( SELECT UserID, Count(tblEquipment.ID) as AssetCount FROM tblEquipment LEFT JOIN tblUsers ON tblEquipment.UserID = tblUsers.ID GROUP BY UserID ) q ON tblUsers.ID = q.UserID
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!