Using "select" in sql (oracle), failed to fetch

Question

Using "select" in sql (oracle), failed to fetch

Navigation

#1 by (0 votes)

0

I have to solve the following question:

1.CONSULT THE NAME (DESCRIPTION) OF THE PRODUCTS ACQUIRED BY HOOPS AND GOOD SPORT CLIENTS IN 1990.

The command used for the search was:

select p.DESCRIPTION 
from PRODUCT p, SALES_ORDER s, ITEM i, CUSTOMER c
where c.NAME = "HOOPS" 
  and s.ORDER_DATE like "%90" 
  and c.COSTUMER_ID = s.COSTUMER_ID 
  and s.ORDER_ID = i.ORDER_ID 
  and i.PRODUCT_ID = p.PRODUCT_ID;

And I got the following error: ERROR on line 1:

ORA-00904: "S". "COSTUMER_ID": Invalid identifier

The diagram used has been tested and has the necessary FKs.

DIAGRAM:

sql oracle

asked by anonymous 30.08.2017 / 06:24

1 answer

RN Navigation - Draw Navigator How to make a join of 2 tables and where 2 fields of table A refer to the same field as table B?

score 0 · Accepted Answer

select 
    p.DESCRIPTION 
from PRODUCT p
inner join ITEM i on i.PRODUCT_ID = p.PRODUCT_ID
inner join SALES_ORDER s on s.ORDER_ID = i.ORDER_ID 
inner join CUSTOMER c on c.COSTUMER_ID = s.COSTUMER_ID
where c.NAME = "HOOPS" 
and s.ORDER_DATE like "%90";