诡异的问题

 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'.

这个语句取不到值

?mid=&wid=51824&sid=&tid=8555&rid=LOADED&custom1=mp.csdn.net&custom2=%2Fpostedit&t=1572577737744?mid=&wid=51824&sid=&tid=8555&rid=FINISHED&custom1=mp.csdn.net&t=1572577737744

    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'.

 

posted @ 2019-11-01 11:12  linhuang  阅读(3)  评论(0编辑  收藏  举报  来源