1
select `md`.`MobileID` AS `MobileId`,`md`.`ClientID` AS `ClientId`,`md`.`LocationID` AS `LocationId`,`md`.`ContactID` AS `ContactId`,`md`.`OsType` AS `OsType`,`md`.`DeviceType` AS `DeviceType`,`mdi`.`DeviceName` AS `DeviceName`,`mdi`.`OsVersion` AS `OsVersion`,`md`.`PropertyStatus` AS `PropertyStatus`,`mdi`.`LastContact` AS `LastContact`,`md`.`InternalStatus` AS `MDM Installed` from (`labtech`.`mobiledevices` `md` join `labtech`.`mobiledeviceinfo` `mdi`) where (`md`.`MobileID` = `mdi`.`MobileID`)