内连接和外连接

ctlly1314

程序如下：
REPORT YTEST015 .
*define structure
DATA: BEGIN OF ARCD,
      CARRID TYPE SPFLI-CARRID,
      CONNID TYPE SPFLI-CONNID,
      FLDATE TYPE SFLIGHT-FLDATE,
      END OF ARCD.
*work place
DATA ARCD1 LIKE ARCD.
SELECT SPFLI~CARRID SPFLI~CONNID SFLIGHT~FLDATE INTO ARCD1 FROM SPFLI
    INNER JOIN SFLIGHT ON SPFLI~CARRID=SFLIGHT~CARRID
          AND SPFLI~CONNID = SFLIGHT~CONNID UP TO 10 ROWS.
WRITE:/ ARCD1-CARRID,ARCD1-CONNID,ARCD1-FLDATE.
ENDSELECT.

调试后报错为：“AND" is not a valid comparison operator.
不管怎么修改还是出现这样的错误！

admin

刚试了一下：

REPORT YTEST015 .
*define structure
DATA: BEGIN OF ARCD,
      CARRID TYPE SPFLI-CARRID,
      CONNID TYPE SPFLI-CONNID,
      FLDATE TYPE SFLIGHT-FLDATE,
      END OF ARCD.
*work place
DATA ARCD1 LIKE ARCD.
SELECT T1~CARRID
       T1~CONNID
       T2~FLDATE
    INTO ARCD1
    FROM SPFLI AS T1

    inner JOIN SFLIGHT AS T2
    ON T1~CARRID = T2~CARRID
    AND T1~CONNID = T2~CONNID
    UP TO 10 ROWS.

WRITE:/ ARCD1-CARRID,ARCD1-CONNID,ARCD1-FLDATE.
endselect.

这样是可以的。

ctlly1314

回复 2# admin


    谢谢老大！

冰糖葫芦

学习