Yardım İKİ TABLO BAĞLANTI SORUNU

SELECT
  P.CODE 'SİCİL NO',
  ISNULL(P.NAME+' '+P.SURNAME,'') 'ADI SOYADI',
  CONVERT(NVARCHAR,P.INDATE,104) 'İŞE GİRİŞ TARİHİ',
 
  [EŞ],
  [EŞ DOĞUM TARİHİ]

  FROM
  LH_001_PERSON P
 
  OUTER APPLY
  (SELECT * FROM (SELECT NAME+' '+SURNAME [EŞ] , ROW_NUMBER() OVER(ORDER BY LREF) SIRA FROM LH_001_FAMILY WHERE PERREF = P.LREF AND RELATION = 1) TBL WHERE SIRA=1) AS E1 OUTER APPLY
 
  (SELECT * FROM (SELECT BIRTHDATE [EŞ DOĞUM TARİHİ], ROW_NUMBER() OVER(ORDER BY PERI.LREF) SIRA FROM LH_001_PERIDINF PERI JOIN
  LH_001_FAMILY F ON F.IDREF=PERI.LREF) TBL WHERE SIRA=1) AS E2