通信通道的文件结束

SELECT (SELECT MAX(BEGINDATE.BEGIN_DATE)
  FROM (SELECT P.ARCHIVES_BUILD_DATE AS BEGIN_DATE 
  FROM PEOPLE_ARCHIVES
  WHERE PEOPLE_ARCHIVES.PEOPLE_SN = P.PEOPLE_SN
  UNION 
  SELECT P.DJ_DATE 
  FROM PEOPLE_ARCHIVES
  WHERE PEOPLE_ARCHIVES.PEOPLE_SN = P.PEOPLE_SN
  UNION 
  SELECT JKWT.NCZ_YES_DATE
  FROM PEOPLE_JKWT
  WHERE PEOPLE_JKWT.PEOPLE_SN = P.PEOPLE_SN) BEGINDATE) AS YES_BEGIN_DATE
  FROM PEOPLE_ARCHIVES P
  INNER JOIN PEOPLE_JKWT JKWT ON P.PEOPLE_SN = JKWT.PEOPLE_SN

补充：应该是union的问题，求解？

你这是要干嘛？