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, '3' AS RELATION, FamilyReport.[Identity Number for Spouse] AS PID, KMSTPNEL.[Family First Name] AS PID_FNAME, ' ' AS PID_MNAME, KMSTPNEL.[Family Last Name] AS PID_LNAME, IIf(KMSTPNEL.[Family Title]='','1',IIf(KMSTPNEL.[Family Title]='ҧ','2',IIf(KMSTPNEL.[Family Title]='..','2',''))) AS PID_SEX, ' ' AS PID_BIRTHDATE, ' ' AS PID_NATION, ' ' AS PID_RELIGION, ' ' AS CHILD_INCOMPETENT, ' ' AS CHILD_REGULARITY
FROM (KMSTPNEL INNER JOIN 2_Employee ON KMSTPNEL.[Personnel ID]=[2_Employee].[Personnel ID]) LEFT JOIN FamilyReport ON (KMSTPNEL.[Family First Name]=FamilyReport.[First name]) AND (KMSTPNEL.[Personnel ID]=FamilyReport.PersNo)
WHERE (((KMSTPNEL.[Family First Name])<>'') And ((KMSTPNEL.[Marital Status])="1")) And FamilyReport.Membr='1';
