1
select `labtech`.`hotfix`.`ComputerID` AS `ComputerID`,`labtech`.`hotfix`.`HotFixID` AS `HotFixID`,`labtech`.`hotfix`.`Installed` AS `Installed`,`labtech`.`hotfix`.`Approved` AS `Approved`,`labtech`.`hotfix`.`Pushed` AS `Pushed`,`labtech`.`hotfixdata`.`kbID` AS `kbID`,`labtech`.`hotfixdata`.`Title` AS `Title`,`labtech`.`hotfixdata`.`OS` AS `OS`,`labtech`.`hotfixdata`.`Category` AS `Category`,`labtech`.`hotfixdata`.`Description` AS `Description`,`labtech`.`hotfixdata`.`SupportURL` AS `SupportURL`,`labtech`.`hotfixdata`.`Severity` AS `Severity`,`labtech`.`hotfixdata`.`CategoryName` AS `CategoryName`,`labtech`.`hotfixdata`.`PatchType` AS `PatchType`,`labtech`.`hotfixdata`.`Uninstall` AS `UNINSTALL` from (`labtech`.`hotfix` join `labtech`.`hotfixdata` on(((`labtech`.`hotfix`.`HotFixID` = `labtech`.`hotfixdata`.`HotFixID`) and (`labtech`.`hotfix`.`OS` = `labtech`.`hotfixdata`.`OS`))))