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
| 번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
|---|---|---|---|---|
| 431 | REPORT z03_10. | sapjoy | 2012.07.30 | 1643 |
| 430 | REPORT z03_09. | sapjoy | 2012.07.30 | 1558 |
| 429 | REPORT z03_08. | sapjoy | 2012.07.30 | 1534 |
| » | REPORT Z03_07. | sapjoy | 2012.07.30 | 1532 |
| 427 | REPORT z03_06. | sapjoy | 2012.07.30 | 1636 |
| 426 | REPORT Z03_05. | sapjoy | 2012.07.30 | 1532 |
| 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 | 1755 |
| 422 | REPORT Z03_01. | sapjoy | 2012.07.30 | 1677 |
| 421 | REPORT z02_26 | sapjoy | 2012.07.30 | 1635 |
| 420 | REPORT z02_25. | sapjoy | 2012.07.30 | 1597 |
| 419 | REPORT z02_24. | sapjoy | 2012.07.30 | 1785 |
| 418 | REPORT z02_23. | sapjoy | 2012.07.30 | 1579 |
| 417 | REPORT z02_22. | sapjoy | 2012.07.30 | 1675 |
| 416 | REPORT Z02_21. | sapjoy | 2012.07.30 | 1676 |
| 415 | REPORT z02_20. | sapjoy | 2012.07.30 | 1616 |
| 414 | REPORT Z02_19. | sapjoy | 2012.07.30 | 1655 |
| 413 | REPORT z02_18. | sapjoy | 2012.07.30 | 1671 |
| 412 | REPORT Z02_17. | sapjoy | 2012.07.30 | 1505 |
