MySQL: JOINS are easy (INNER, LEFT, RIGHT)

#MySQL #course #tutorial 00:00:00 intro 00:01:46 INNER JOIN 00:03:48 LEFT JOIN 00:04:20 RIGHT JOIN 00:04:45 conclusion -- INNER JOIN selects records that have a matching key in both tables. SELECT * FROM transactions INNER JOIN customers ON transactions.customer_id = customers.customer_id; -- LEFT JOIN returns all records from the left table -- and the matching records from the right table SELECT * FROM transactions LEFT JOIN customers ON transactions.customer_id = customers.customer_id; -- RIGHT JOIN returns all records from the right table -- and the matching records from the left table SELECT * FROM transactions RIGHT JOIN customers ON transactions.customer_id = customers.customer_id;