SELECT WITH JOINS Select with Joins 1. It is used to bring the data simultaneously from multiple tables. 2. That means the multiple tables must be joined using one or two field. 3. There should be at least one common field between tables. 4. We have 2 types of joins. 1. INNER JOIN 1. Inner Join is used to bring comparable (matching) records between tables. 2. Unmatched Records won’t be selected. 2. OUTER JOIN 1. It joins all the records from the first table or left table will be selected first. 2. If there are any comparable (matching) records from second, third tables, then the data will be displayed. 3. And if there are no matching records, the data will be displayed as blank from second and third tables. EXAMPLE PROGRAM ON INNER JOIN TYPES : BEGIN OF TY_VBAK_VBAP , VBELN TYPE VBAK - VBELN , ERDAT TYPE VBAK - ERDAT , ...