This is my query now but it fails: SELECT p.csname,p.hotfix_id from patches p right outer join system_info i on p.csname = i.computer_name where hotfix_id = 'KB1234567'