Question: I'm using SQL, and the question is List the order number and order date for each order that either was placed by Almondton General Store
I'm using SQL, and the question is List the order number and order date for each order that either was placed by Almondton General Store or that contains an order line for a Fire engine?
I put in the following code, but I keep getting an error that says "ORA-00933: SQL command not properly ended" I ran SQL plus from the command line and it appears to say that using the 'as' command is the problem. Im still not sure how that is an issue, though.
select distinct o.Order_NUM, o.Order_DATE FROM ORDERS as o inner join order_line as ol on ol.ORDER_NUM=o.ORDER_NUM inner join item as i on i.ITEM_NUM=ol.ITEM_NUM inner join customer as c on c.CUSTOMER_NUM=o.CUSTOMER_NUM where i.DESCRIPTION='fire engine' or c.CUSTOMER_NAME ='almondton general store';
Any Help would be greatly appreciated.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
