sql那里错啦。查不出数据
求大神指点,sql那里错啦。查不出数据,谢谢
MERGE INTO TMP3B90C8C7F05911E79701005056F T1
USING(SELECT T3.FDATAVALUE AS FDATAVALUE ,T2.FENTRYID AS FENTRYID FROM T_SAL_ORDERENTRY T2
LEFT JOIN T_BAS_ASSISTANTDATAENTRY_L T3 ON T2.F_PAEZ_ASSISTANT=T3.FENTRYID) T4
ON (T1.FORDERID=T4.FENTRYID)
WHEN MATCHED THEN
UPDATE SET T1.FLYC_Text=T4.FDATAVALUE
WHEN NOT MATCHED THEN
INSERT (T1.FLYC_Text) VALUES (NULL);