[SAP Query] 테이블 JOIN

1. 테이블 join 

SELECT {Column List} FROM [TABLE A]

LEFT/RIGHT/INNER JOIN [TABLE B - Join할 대상 테이블 명]

ON [TABLE A].PrimaryKey = [TABLE B].ForeignKey

 

[예]

SELECT * FROM EKPO
LEFT JOIN EBAN
ON EKPO.EBELN = EBAN.EBELN

 

2. Key 여러개로 join하는 방법 

SELECT {Column List} FROM [TABLE A]

LEFT/RIGHT/INNER JOIN [TABLE B - Join할 대상 테이블 명]

ON [TABLE A].PrimaryKey1 = [TABLE B].ForeignKey1 and [TABLE A].PrimaryKey2 = [TABLE B].ForeignKey2

 

[예]

SELECT * FROM EKPO
LEFT JOIN EBAN
ON EKPO.EBELN = EBAN.EBELN and EKPO.EBELP=EBAN.EBELP