REPORT Z04_021.
DATA: BEGIN OF wa,
carrid TYPE spfli-carrid,
connid TYPE spfli-connid,
fldate TYPE sflight-fldate,
END OF wa,
itab LIKE standard TABLE OF wa.
SELECT a~carrid a~connid b~fldate
INTO CORRESPONDING FIELDS OF TABLE itab
FROM ( spfli AS p
INNER JOIN sflight AS f ON a~carrid = b~carrid AND
a~connid = b~connid )
WHERE b~seatsmax > b~seatsocc.
WRITE : '---INNER JOIN 결과---'.
LOOP AT itab INTO wa.
WRITE: / wa-carrid, wa-connid, wa-fldate.
ENDLOOP.
댓글 4
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
151 | REPORT Z04_007 [1] | sapjoy | 2008.04.15 | 2140 |
150 | REPORT z04_014 | sapjoy | 2007.05.22 | 2218 |
149 | REPORT Z04_013 | sapjoy | 2008.04.15 | 2304 |
148 | REPORT Z04_030 [1] | sapjoy | 2008.04.15 | 2268 |
147 | REPORT Z04_004 [7] | sapjoy | 2008.04.15 | 2487 |
146 | REPORT Z04_008 [1] | sapjoy | 2007.05.17 | 2150 |
145 | REPORT Z04_022 | sapjoy | 2007.05.17 | 2092 |
» | REPORT Z04_021 [4] | sapjoy | 2007.05.17 | 2206 |
143 | REPORT Z04_002 | sapjoy | 2008.04.15 | 2447 |
142 | REPORT Z04_001 | sapjoy | 2007.05.16 | 2375 |
141 | REPORT Z03_030 | sapjoy | 2007.05.16 | 2166 |
140 | REPORT z03_029 [1] | sapjoy | 2007.05.16 | 2132 |
139 | REPORT Z03_028 | sapjoy | 2007.05.16 | 2102 |
138 | REPORT z03_022 [2] | sapjoy | 2007.05.15 | 2111 |
137 | REPORT Z03_017 [5] | sapjoy | 2008.04.15 | 2269 |
136 | REPORT Z03_019 [4] | sapjoy | 2008.04.15 | 2148 |
135 | REPORT Z03_018 [3] | sapjoy | 2006.12.03 | 2607 |
134 | REPORT Z03_016 [1] | sapjoy | 2007.05.15 | 2220 |
133 | REPORT Z03_015 | sapjoy | 2007.05.15 | 2131 |
132 | REPORT Z03_013 [4] | sapjoy | 2007.05.15 | 2388 |
Alias가 약간 잘못되어있네요.
SELECT a~carrid a~connid b~fldate
INTO CORRESPONDING FIELDS OF TABLE itab
FROM ( spfli AS a
INNER JOIN sflight AS b ON a~carrid = b~carrid AND
a~connid = b~connid )
WHERE b~seatsmax > b~seatsocc.