Day 20 — INNER JOIN vs LEFT OUTER JOIN

1. What is the difference between INNER JOIN and LEFT OUTER JOIN? 2. When do we use each JOIN?

1. INNER JOIN returns only matching records from both tables. 2. LEFT OUTER JOIN returns all records from the left table. 3. Matching records from the right table are also displayed. 4. LEFT OUTER JOIN displays NULL values if no matching record exists. 5. JOINs help retrieve related data in a single query.

1. Join VBAK and VBAP using INNER JOIN. 2. Display Sales Orders that have Item data. 3. Use LEFT OUTER JOIN with KNA1 and VBAK. 4. Display all Customers, even if they have no Sales Orders. 5. This provides complete business information.

1. What is INNER JOIN? 2. What is LEFT OUTER JOIN? 3. When do we use LEFT OUTER JOIN? 4. Which JOIN returns only matching records? 5. Give one real-time example.