SELECT A.Y as Y,
H.JC AS MC,
A.JCRQ AS JKRQ,
A.FMRQ AS FMRQ,
to_char(B.CYSJ,'YYYYMMDD') AS CYSJ,
A.XM AS XM,
B.ZJHM AS SFZH,
B.ZJHM AS XQ,
A.YSGH,
A.YKID
FROM (SELECT Y.Y,Y.JCRQ,F.FMRQ,F.XM,F.SFZHM,Y.DJRYGH AS YSGH,F.YKID
FROM FYBJ.TB_FB_YKXX Y, FYBJ.TB_FB_FMJL F
WHERE Y.YKID = F.YKID
AND ABS(Y.YCQ - F.FMRQ) < 30
AND SFZHM IS NOT NULL
AND Y.JCRQ<=F.FMRQ
AND F.FMRQ>=(SYSDATE-37)) A
JOIN (SELECT S.Y, P.ZJHM, S.CYSJ
FROM CORE.Patient_Information P,
CORE.MEDICAL_RECORD S
WHERE P.KH = S.KH
AND P.KLX = S.KLX
AND LENGTH(ZJHM) >= 15
AND TO_CHAR(CYSJ,'YYYYMMDD')>=TO_CHAR(SYSDATE-7,'YYYYMMDD')) B
ON A.SFZHM = B.ZJHM
JOIN V_DIC_HOSPITAL H
ON A.Y = H.DM
```ORACLE中用A join B会A.字段名无效,用from A,B where A.字段名=B.字段名就可以
别说什么A表没字段,不可能,我都分别查过A,B表,两表都能查询出来,字段名没错,字段类型没错,数据也没错,就是找不到wen'ti'de'yuan'yin