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:
- What is SAP ABAP?
- SAP ABAP Training Tutorials for Beginners
- ABAP Data Types and Objects
- SAP ABAP System Variables
- ABAP Internal Tables
- ABAP Table Control
- SSCR Key in SAP ABAP
- ABAP Script Commands
- ABAP Menu & Screen Painter
- ABAP Search Help
- ABAP Lock Object
- ABAP Function Modules
- ABAP Classes
- SAP ABAP Performance Tuning
- ABAP Smartforms
- ABAP SAPScript
- ABAP User Exits, Customer Exits and BADI
- SAP ABAP PBO and PAI
- ABAP Core Data Service
- ABAP Native vs. Open SQL
×
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.