Question: 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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

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...

Help! im sure what is wrong with my query im getting this message below. plesse herm me fugure out whats wrong with my query. SELECT DISTINCT tblPAandPB.P_B, tblPAandPB.P_A, DO_RS_P.REPLACNG_PT_NR AS...

Hi, I'm having an issue with this Simnet project and I was wondering if anyone could help me. There is only one issue: Step 3a, in the instruction pdf that I have attached. When my project is graded...

1. Your company uses 2 tables to store product information named LocalProducs and InternationalProducts. You also use a table named Orders that stores open order information. You must retrieve the ID...

Business Event Analysis: Complete the following table based on the specified NBD event. Receive Shipment (From Supplier) Trigger(s) (also indicate type) Collected Data (originates as input for event)...

please read and answers the questions 1. What was the most interesting thing in the chapter to you? Why? 2. What in the chapter were you able to directly relate to your own communication...

What's wrong with my SQL code? _________________ select invoice_number, invoice_total, (payment_total + credit_total) as 'payment_credit_total', (invoice_total - payment_total - credit_total) as...

Few SQL questions I'm getting a syntax error SELECT invoice_due_date,invoice_total,invoice_total/10 as 10%,invoice_total+(invoice_total/10) as plus_10% FROM invoices WHERE invoice_total>=500 AND...

This program is in MASM using Irvine 32 bit library. I have it written, but I'm getting a syntax error that I can't resolve. Can anyone please help? INCLUDE Irvine32.inc .data inFileName byte...

Calls to a telephone system follow a Poisson distribution with a mean of five calls per minute. (a) What is the name applied to the distribution and parameter values of the time until the tenth call?...

B. Ahmed, as an auditor for Al Saf traders has found that the sales were reported in the Income statement as RO 158,552. Since he is skeptical about the sales assertion and in order to verify and...

Question 5 6 0 1 . 7 5 pts Day - to - day trading practices of securities ferms currently may be regulated by which of the following? FINRA II . SEC III. Federal Reserve I and lif orly landil onty...

What is the pretax cost of debt for a firm in the 21% tax bracket that has a 9% after-tax cost of debt?

1-1 How are information systems transforming business, and why are they so essential for running and managing a business today?

As stated in the case, Therese strongly believes that the changes she was seeking for women in the workplace, were the dual responsibility of organizations and women themselves. Critically evaluate...

Research provides evidence that organisations that invest in Diversity and Inclusion are more innovative in the long run and outperform organisations that do not. Critically evaluate the...