REPORT Z04_022.
DATA: BEGIN OF wa,
carrid TYPE sflight-carrid,
connid TYPE spfli-connid,
END OF wa,
itab LIKE SORTED TABLE OF wa
WITH NON-UNIQUE KEY carrid.
SELECT a~carrid b~connid
INTO CORRESPONDING FIELDS OF TABLE itab
FROM sflight AS a
LEFT OUTER JOIN spfli AS b ON a~carrid = b~carrid AND
b~cityfrom = '
WRITE 'OUTER JOIN 결과'
LOOP AT itab INTO wa.
WRITE: / wa-carrid, wa-connid.
ENDLOOP.
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
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 |
» | REPORT Z04_022 | sapjoy | 2007.05.17 | 2092 |
144 | 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 |