SELECT HOSPCODE, DISTINCT PER_NAME,DATE_SERV,CHIEFCOMP,BTEMP,SBP,DBP FROM mas_person_onerecord INNER JOIN f43_service ON mas_person_onerecord.CID=f43_service.CID
WHERE mas_person_onerecord.$strKeyword2 LIKE '%".$strKeyword."%'
ORDER BY f43_service.DATE_SERV DESC