tubeshowcase●1,669,464 videos♡ My collection 0
← Learn to Code

Learn to Code05:04

Learn MySQL joins in 5 minutes!

Bro Code ↗

From the creator

#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;

Published 2022-10-30 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.

Keep exploring Learn to Code