Hi All,
Inner Join vs Left Outer Join
Can anyone please explain how inner join works on two tables and on three tables?if possible with example?
Regards,
Pacchi
Difference between Inner and Left Outer Join
Updated May 18, 2018
Comments
Recommended Posts:
- ABAP Data Types and Objects
- SAP ABAP System Variables
- ABAP Table Control
- ABAP Date & Time
- ABAP Data Dictionary
- ABAP Views Types
- SSCR Key in SAP ABAP
- ABAP Script Commands
- ABAP Menu & Screen Painter
- ABAP Lock Object
- ABAP Function Modules
- ABAP Classes
- SAP ABAP Performance Tuning
- ABAP OOP's
- ABAP Smartforms
- ABAP User Exits, Customer Exits and BADI
- SAP ABAP PBO and PAI
- ABAP Native vs. Open SQL
- SAP ABAP Interview Questions
- SAP ABAP Certification Cost
×
TABLES: mara, marc, mard.
TYPES: BEGIN OF t_mara,
matnr LIKE mara-matnr,
END OF t_mara.
DATA: it_mara TYPE STANDARD TABLE OF t_mara WITH HEADER LINE.
SELECT mara~matnr
INTO CORRESPONDING FIELDS OF TABLE it_mara
FROM mara INNER JOIN marc ON ( mara~matnr = marc~matnr )
INNER JOIN mard ON ( marc~matnr = mard~matnr AND marc~werks = mard~werks )
* where mard~lgort = ' Storage Location Here you can use where class
" and mara~matnr = ' Matnr.