MySQL

Syntax

-- SELECT all columns from multiple tables
SELECT * FROM `order details`
JOIN customers ON `order details`.customer_id = customers.id
JOIN products ON `order details`.product_id = products.id;

-- WHERE clause with multiple conditions
WHERE orders.`status (paid/unpaid)` = 'shipped'
AND customers.country = 'United States'
AND products.price > 50
Copy to clipboard