REPORT Z03_07.
TYPES: BEGIN OF t_str,
carrid TYPE sflight-carrid,
carrname TYPE scarr-carrname,
END OF t_str.
DATA: gs_str TYPE t_str.
SELECT SINGLE a~carrid b~carrname
INTO CORRESPONDING FIELDS OF gs_str
FROM sflight AS a
LEFT OUTER JOIN scarr AS b
ON a~carrid EQ b~carrid
WHERE a~carrid = 'AA'.
WRITE : gs_str-carrid, gs_str-carrname.
TYPES: BEGIN OF t_str,
carrid TYPE sflight-carrid,
carrname TYPE scarr-carrname,
END OF t_str.
DATA: gs_str TYPE t_str.
SELECT SINGLE a~carrid b~carrname
INTO CORRESPONDING FIELDS OF gs_str
FROM sflight AS a
LEFT OUTER JOIN scarr AS b
ON a~carrid EQ b~carrid
WHERE a~carrid = 'AA'.
WRITE : gs_str-carrid, gs_str-carrname.
댓글 0
| 번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
|---|---|---|---|---|
| 429 | REPORT z03_08. | sapjoy | 2012.07.30 | 1532 |
| » | REPORT Z03_07. | sapjoy | 2012.07.30 | 1532 |
| 427 | REPORT z03_06. | sapjoy | 2012.07.30 | 1634 |
| 426 | REPORT Z03_05. | sapjoy | 2012.07.30 | 1531 |
| 425 | REPORT z03_04. | sapjoy | 2012.07.30 | 1639 |
| 424 | REPORT z03_03. [2] | sapjoy | 2012.07.30 | 1836 |
| 423 | REPORT z03_02. | sapjoy | 2012.07.30 | 1753 |
| 422 | REPORT Z03_01. | sapjoy | 2012.07.30 | 1677 |
| 421 | REPORT z02_26 | sapjoy | 2012.07.30 | 1634 |
| 420 | REPORT z02_25. | sapjoy | 2012.07.30 | 1596 |
| 419 | REPORT z02_24. | sapjoy | 2012.07.30 | 1783 |
| 418 | REPORT z02_23. | sapjoy | 2012.07.30 | 1579 |
| 417 | REPORT z02_22. | sapjoy | 2012.07.30 | 1674 |
| 416 | REPORT Z02_21. | sapjoy | 2012.07.30 | 1675 |
| 415 | REPORT z02_20. | sapjoy | 2012.07.30 | 1613 |
| 414 | REPORT Z02_19. | sapjoy | 2012.07.30 | 1652 |
| 413 | REPORT z02_18. | sapjoy | 2012.07.30 | 1671 |
| 412 | REPORT Z02_17. | sapjoy | 2012.07.30 | 1504 |
| 411 | REPORT Z02_16. | sapjoy | 2012.07.30 | 1509 |
| 410 | REPORT z02_15. | sapjoy | 2012.07.30 | 1619 |
