诡异的问题

mac2025-03-30  16

 DD07T~DOMNAME EQ 'ZD_WFTYPE'这个放在where条件和放在join条件后效果不一样 

这个是能取到值的

SELECT WF_ID, WF_NAME, BEGDA, ENDDA, DD07T~DDTEXT AS WFTYPE INTO TABLE @DATA(LT_TABLE) FROM YAC_T_LIST LEFT JOIN DD07T ON YAC_T_LIST~WFTYPE EQ DD07T~VALPOS AND DD07T~DOMNAME EQ 'ZD_WFTYPE'.

这个语句取不到值

SELECT WF_ID, WF_NAME, BEGDA, ENDDA, DD07T~DDTEXT AS WFTYPE INTO TABLE @DATA(LT_TABLE) FROM YAC_T_LIST LEFT JOIN DD07T ON YAC_T_LIST~WFTYPE EQ DD07T~VALPOS WHERE DD07T~DOMNAME EQ 'ZD_WFTYPE'.

 

最新回复(0)