SQL Interview Question: Explain the Different Types of JOIN
Short answer: joins combine rows from two tables based on a condition. They differ in what happens to rows that have no match. -- customers: (1, Asha), (2, Ravi), (3, Meera) -- orders: (101, customer 1), (102, customer 1), (103, customer 9) INNER JOIN: only ma...