What to fix to make a query for a selection from two tables work?

Question

MySQL

Why is the request not working?

$query = "SELECT products.name AS product, users.name AS user, orders.count AS qty FROM orders LEFT JOIN users ON orders.user_id = users.id LEFT JOIN products ON orders.product_id = products.id WHERE id = $ord_id";

Answer 1

Since several tables are used for the id parameter, you need to specify the table, orders.id instead of id