Selecting from Multiple tables

Question 1

INNER JOIN

Answer 1

SELECT products.name,orders.order_time FROM orders
INNER JOIN products ON orders.product_id = products.id;

SELECT p.name,o.order_time FROM orders o
JOIN products p ON o.product_id = p.id;