1
select `v1`.`ClientID` AS `ClientID`,`v1`.`LocationID` AS `LocationID`,`v1`.`hvhid` AS `hvhid`,`v1`.`namespace` AS `namespace`,`v1`.`classname` AS `classname`,`v1`.`HVEName` AS `HVEName`,`v1`.`Value` AS `DeviceName`,`v1`.`hvhname` AS `hvhname`,`v2`.`HVPName` AS `Property`,`v2`.`Value` AS `PValue` from (`labtech`.`v_hvcimdata` `v1` join `labtech`.`v_hvcimdata` `v2` on((`v1`.`HVPName` = 'Caption')))