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 | 2141 |
150 | REPORT z04_014 | sapjoy | 2007.05.22 | 2219 |
149 | REPORT Z04_013 | sapjoy | 2008.04.15 | 2305 |
148 | REPORT Z04_030 [1] | sapjoy | 2008.04.15 | 2269 |
147 | REPORT Z04_004 [7] | sapjoy | 2008.04.15 | 2489 |
146 | REPORT Z04_008 [1] | sapjoy | 2007.05.17 | 2151 |
145 | REPORT Z04_022 | sapjoy | 2007.05.17 | 2094 |
» | REPORT Z04_021 [4] | sapjoy | 2007.05.17 | 2209 |
143 | REPORT Z04_002 | sapjoy | 2008.04.15 | 2448 |
142 | REPORT Z04_001 | sapjoy | 2007.05.16 | 2376 |
141 | REPORT Z03_030 | sapjoy | 2007.05.16 | 2168 |
140 | REPORT z03_029 [1] | sapjoy | 2007.05.16 | 2132 |
139 | REPORT Z03_028 | sapjoy | 2007.05.16 | 2107 |
138 | REPORT z03_022 [2] | sapjoy | 2007.05.15 | 2112 |
137 | REPORT Z03_017 [5] | sapjoy | 2008.04.15 | 2270 |
136 | REPORT Z03_019 [4] | sapjoy | 2008.04.15 | 2149 |
135 | REPORT Z03_018 [3] | sapjoy | 2006.12.03 | 2609 |
134 | REPORT Z03_016 [1] | sapjoy | 2007.05.15 | 2222 |
133 | REPORT Z03_015 | sapjoy | 2007.05.15 | 2132 |
132 | REPORT Z03_013 [4] | sapjoy | 2007.05.15 | 2390 |
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.