Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 15th International Conference Dexa 2004 Zaragoza Spain August 30 September 3 2004 Proceedings Lncs 3180

Authors: Fernando Galindo ,Makoto Takizawa ,Roland Traunmuller

2004th Edition

3540229361, 978-3540229360

More Books

Students also viewed these Databases questions