Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SQL Im getting a syntax error in my query expression. Can anyone see what Im doing wrong? SELECT DISTINCT C.CUSTOMER_NUM, C.CUSTOMER_NAME FROM CUSTOMER AS C
SQL
Im getting a syntax error in my query expression. Can anyone see what Im doing wrong?
SELECT DISTINCT C.CUSTOMER_NUM, C.CUSTOMER_NAME FROM CUSTOMER AS C INNER JOIN ORDERS AS O ON O.CUSTOMER_NUM = C.CUSTOMER_NUM INNER JOIN ORDER_LINE AS OLON OL.ORDER_NUM = O.ORDER_NUM INNER JOIN ITEM AS I ON I.ITEM_NUM - OL.ITEM_NUM WHERE I.DESCRIPTION = 'ROCKING HORSE';
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started