Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Correlated Subqueries allowed in FROM clause?

Correlated Subqueries allowed in FROM clause?

From: <mitch23_at_hotmail.com>
Date: Mon, 14 Jun 1999 18:42:14 GMT
Message-ID: <7k3ie4$66$1@nnrp1.deja.com>


I have successfully executed a SQL query that has correlated subquery in the FROM clase of the statement in MS Access but am having no luck doing the same in Oracle 8...is this allowed? Below is the SQL statement as executed through Access. If possible, could someone give the the Oracle synatx translation? Thanks

SELECT O.LOGICAL_NAME, D.VENDOR, D.MODEL, D.SERIAL_NO_, (SELECT O2.PURCH_ACTUAL_COST FROM OWNERSHIP AS O2 WHERE O2.LOGICAL_NAME = O.LOGICAL_NAME AND O2.OWNERSHIP_BEGIN_DATE = (SELECT MIN (O3.OWNERSHIP_BEGIN_DATE) FROM OWNERSHIP AS O3 WHERE O3.LOGICAL_NAME = O2.LOGICAL_NAME)) AS PURCH_ACTUAL_COST, D.LOCATION, D.TYPE, D.ROOM,

D.MANUFACTURER, D.U_CONTACT_NAME, O.OWNERSHIP_BEGIN_DATE,
O.CAP_INV_REC_CODE, O.CUST_BILLING_NB, O.RETIRED_DATE,
O.OWNERSHIP_TRANSFER_PRICE, O.OWNERSHIP_END_DATE
FROM DEVICE AS D INNER JOIN OWNERSHIP AS O ON D.LOGICAL_NAME = O.LOGICAL_NAME
WHERE PURCH_ACTUAL_COST >= 5000 AND O.OWNERSHIP_BEGIN_DATE <= #06/30/1999# AND O.OWNERSHIP_END_DATE IS NULL ORDER BY O.LOGICAL_NAME; Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 14 1999 - 13:42:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US