SELECT [1_Personal1].PID_SELECT, [1_Personal1].PID_SELECT_FNAME, [1_Personal1].PID_SELECT_MNAME, [1_Personal1].PID_SELECT_LNAME, [1_Personal1].PID_SELECT_SEX, [1_Personal1].PID_SELECT_BIRTHDATE, [1_Personal1].PID_SELECT_NATION, [1_Personal1].PID_SELECT_RELIGION, [1_Personal1].WORK_START_DATE, [1_Personal1].POSITION_REGISTER_ID, IIf([1_Personal1].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 1_Personal1 ON KMSCHD01.[Personnel ID]=[1_Personal1].[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';
