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, '4' AS RELATION, FamilyReport.[Identity Number for Father] AS PID, KMSTPNEL.[Father Name] AS PID_FNAME, ' ' AS PID_MNAME, ' ' AS PID_LNAME, '1' AS PID_SEX, ' ' AS PID_BIRTHDATE, ' ' AS PID_NATION, ' ' AS PID_RELIGION, ' ' AS CHILD_INCOMPETENT, ' ' AS CHILD_REGULARITY
FROM (KMSTPNEL INNER JOIN 1_Personal1 ON KMSTPNEL.[Personnel ID]=[1_Personal1].[Personnel ID]) LEFT JOIN FamilyReport ON (KMSTPNEL.[Father Name]=(FamilyReport.ӹ˹Ҫ+' '+(FamilyReport.[First name])+' '+(FamilyReport.[Last name]))) AND (KMSTPNEL.[Personnel ID]=FamilyReport.PersNo)
WHERE (((KMSTPNEL.[Father Name])<>'')) And FamilyReport.Membr='11';
