Oracle: why is there an error?

Question

Oracle

Hello,
in general, there is such a request:

SELECT S.cost
    FROM(
            (
                SELECT shoppingserviceid ,cost,bsid
                FROM service JOIN shopping_service 
                ON service.serviceid = shopping_service.serviceid 
            ) S JOIN provided_service
            ON provided_service.shoppingserviceid = S.shoppingserviceid
        ) P JOIN provide_service_detail
        ON  provide_service_detail.providedserviceid = P.providedserviceid

which returns the error
CDbCommand failed to execute the SQL statement: ORA-00933: SQL command not properly ended. The SQL statement executed was:
Thanks in advance!

Answer 1

It’s hard to understand something here, use named queries, everything will fall into place.
WITH query_name AS (subquery)

Answer 2

I did it like this and it works:

SELECT *
    FROM service 
      JOIN shopping_service 
        ON service.serviceid = shopping_service.serviceid
      JOIN provided_service
        ON provided_service.shoppingserviceid = shopping_service.shoppingserviceid
      JOIN provide_service_detail
        ON provide_service_detail.providedserviceid = provided_service.providedserviceid

Answer 3

1. S.cost - not visible at the top level
2. The condition provide_service_detail.providedserviceid = P.providedserviceid will not work
3. You need to rewrite something like this

SELECT S.cost
  FROM (select * from ((SELECT shoppingserviceid, cost, bsid FROM service JOIN shopping_service ON service.serviceid = shopping_service.serviceid) S JOIN
         provided_service ON provided_service.shoppingserviceid = S.shoppingserviceid)) P
  JOIN provide_service_detail
    ON provide_service_detail.providedserviceid = P.providedserviceid