SELECT [2_Employee].PID_SELECT, [2_Employee].PID_SELECT_FNAME, [2_Employee].PID_SELECT_MNAME, [2_Employee].PID_SELECT_LNAME, [2_Employee].PID_SELECT_SEX, [2_Employee].PID_SELECT_BIRTHDATE, [2_Employee].PID_SELECT_NATION, [2_Employee].PID_SELECT_RELIGION, [2_Employee].WORK_START_DATE, [2_Employee].POSITION_REGISTER_ID, IIf([2_Employee].PID_SELECT_SEX='1','1','2') AS RELATION, FamilyReport.[ѵûЪҪ] AS PID, KMSCHD01.[Family First Name] AS PID_FNAME, ' ' AS PID_MNAME, KMSCHD01.[Family Last Name] AS PID_LNAME, IIf(KMSCHD01.[Family Title]='','1',IIf([KMSCHD01.Family Title]='..','1','2')) AS PID_SEX, format([Date of Birth],"00/00/0000") AS PID_BIRTHDATE, ' ' AS PID_NATION, ' ' AS PID_RELIGION, ' ' AS CHILD_INCOMPETENT, iif(((datediff('d',cdate(format(left([Date of Birth],4)+CStr((Cint(right([Date of Birth],4))-543)),"00/00/0000")),Date()))/365)>20,'N','Y') AS CHILD_REGULARITY
FROM (KMSCHD01 INNER JOIN 2_Employee ON KMSCHD01.[Personnel ID]=[2_Employee].[Personnel ID]) LEFT JOIN FamilyReport ON (KMSCHD01.[Family First Name]=FamilyReport.[First name]) AND (KMSCHD01.[Personnel ID]=FamilyReport.PersNo)
WHERE (((KMSCHD01.[Family First Name])<>'')) And FamilyReport.Membr='2';
