SELECT c.customer_id, o.order_id, o.order_date, p.product_name FROM customer c, curr_order o, product p WHERE customer.customer_id = curr_order.customer_id AND o.product_id = p.product_id ORDER BY o.order_amount;
This statement fails when executed. Which change will correct the problem?
1) Include the ORDER_AMOUNT column in the SELECT list
2) Use the table name in the ORDER BY clause.
3) Remove the table aliases from the WHERE clause.
4 Use the table aliases instead of the table names in the WHERE clause.