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 | 2179 |
| 150 | REPORT z04_014 | sapjoy | 2007.05.22 | 2239 |
| 149 | REPORT Z04_013 | sapjoy | 2008.04.15 | 2326 |
| 148 | REPORT Z04_030 [1] | sapjoy | 2008.04.15 | 2312 |
| 147 | REPORT Z04_004 [7] | sapjoy | 2008.04.15 | 2536 |
| 146 | REPORT Z04_008 [1] | sapjoy | 2007.05.17 | 2191 |
| 145 | REPORT Z04_022 | sapjoy | 2007.05.17 | 2113 |
| » | REPORT Z04_021 [4] | sapjoy | 2007.05.17 | 2252 |
| 143 | REPORT Z04_002 | sapjoy | 2008.04.15 | 2475 |
| 142 | REPORT Z04_001 | sapjoy | 2007.05.16 | 2406 |
| 141 | REPORT Z03_030 | sapjoy | 2007.05.16 | 2191 |
| 140 | REPORT z03_029 [1] | sapjoy | 2007.05.16 | 2171 |
| 139 | REPORT Z03_028 | sapjoy | 2007.05.16 | 2129 |
| 138 | REPORT z03_022 [2] | sapjoy | 2007.05.15 | 2158 |
| 137 | REPORT Z03_017 [5] | sapjoy | 2008.04.15 | 2316 |
| 136 | REPORT Z03_019 [4] | sapjoy | 2008.04.15 | 2185 |
| 135 | REPORT Z03_018 [3] | sapjoy | 2006.12.03 | 2653 |
| 134 | REPORT Z03_016 [1] | sapjoy | 2007.05.15 | 2261 |
| 133 | REPORT Z03_015 | sapjoy | 2007.05.15 | 2149 |
| 132 | REPORT Z03_013 [4] | sapjoy | 2007.05.15 | 2431 |
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.