Query Director for 495476-M

select * from rocpersonprofile where srlprofilekeycode in
(select intprofilekeycode from rocauthentication where srlauthenticatekeycode in
(select intauthenticatekeycode
from roccompanyofficer
where chrrecordstatus = 'C'
and chrdesignationcode = 'D'
and vchcompanyno = '495476'
))