INNER JOIN

Get matching records from both tables.

Example

-- INNER JOIN gets matches from both
SELECT u.name, o.total FROM users u INNER JOIN orders o ON u.id = o.user_id;