converting access sql to oracle
Date: Mon, 19 Mar 2001 10:33:55 -0600
Message-ID: <ivqt6.5101$7e6.1907187_at_homer.alpha.net>
Hello,
I am in the process of trying to learn Oracle and was wondering how easy it is to convert access 2000 sql into oracle sql: here is a query that is inserted into another query and I was wondering can I convert this into a oracle query? appreciate any help-- here is the sql
(Main query -- 2 nd query listed below)
SELECT DISTINCT IFSAPP_INVENTORY_TRANSACTION_HIST.PART_NO,
IFSAPP_INVENTORY_PART.SECOND_COMMODITY AS CLASS,
IFSAPP_INVENTORY_PART.DESCRIPTION,
Count(IFSAPP_INVENTORY_TRANSACTION_HIST.PART_NO) AS ISS,
Sum(IFSAPP_INVENTORY_TRANSACTION_HIST.QUANTITY) AS MRP,
SubQtyOnHandSumQry.SumOfQTY_ONHAND AS OH,
IFSAPP_INVENTORY_PART.INVENTORY_VALUE AS COST
FROM (IFSAPP_INVENTORY_TRANSACTION_HIST RIGHT JOIN IFSAPP_INVENTORY_PART ON
IFSAPP_INVENTORY_TRANSACTION_HIST.PART_NO = IFSAPP_INVENTORY_PART.PART_NO)
LEFT JOIN SubQtyOnHandSumQry ON IFSAPP_INVENTORY_PART.PART_NO =
SubQtyOnHandSumQry.PART_NO
WHERE (((IFSAPP_INVENTORY_TRANSACTION_HIST.DATED) Between [To:] And
[From:]))
GROUP BY IFSAPP_INVENTORY_TRANSACTION_HIST.PART_NO,
IFSAPP_INVENTORY_PART.SECOND_COMMODITY, IFSAPP_INVENTORY_PART.DESCRIPTION,
SubQtyOnHandSumQry.SumOfQTY_ONHAND, IFSAPP_INVENTORY_PART.INVENTORY_VALUE,
IFSAPP_INVENTORY_TRANSACTION_HIST.TRANSACTION_CODE
HAVING (((IFSAPP_INVENTORY_TRANSACTION_HIST.TRANSACTION_CODE)="BACFLUSH"));
2nd query(SubQtyOnHandSumQry)
SELECT IFSAPP_INVENTORY_PART_LOCATION.PART_NO,
IFSAPP_INVENTORY_PART_LOCATION.LOCATION_TYPE,
Sum(IFSAPP_INVENTORY_PART_LOCATION.QTY_ONHAND) AS SumOfQTY_ONHAND
FROM IFSAPP_INVENTORY_PART_LOCATION
GROUP BY IFSAPP_INVENTORY_PART_LOCATION.PART_NO,
IFSAPP_INVENTORY_PART_LOCATION.LOCATION_TYPE
HAVING (((IFSAPP_INVENTORY_PART_LOCATION.LOCATION_TYPE)="Picking"));
Received on Mon Mar 19 2001 - 17:33:55 CET