Re: Oracle SQL DISTINCT HELP!!

From: Martin Haltmayer <Martin_Haltmayer_at_in.augsburg.net>
Date: Sun, 05 Sep 1999 11:23:54 +0200
Message-ID: <37D236AA.A0963F21@in.augsburg.net>

What does the construction "REQUIREMENT REQUIREMENT.PART_ID AND PART.ID INTO :sPn, :sPpn" do in your source system? For Oracle I guess the syntax is wrong, and to determine the correct syntax we have to know what this construct did.

Martin

"Gary C. Greenwood" wrote:
>
> I'm coming from Centura SQLBase to Oracle the folling SQL is giving a
> ORA-01791 not a SELECT ed expression. I'd appreciate any help in fixing it.
>
> SELECT DISTINCT REQUIREMENT.PART_ID, PART.ID
> FROM PART, WORK_ORDER, REQUIREMENT REQUIREMENT.PART_ID AND PART.ID
> INTO :sPn, :sPpn
> WHERE PART.ID = WORK_ORDER.PART_ID
> AND WORK_ORDER.BASE_ID = REQUIREMENT.WORKORDER_BASE_ID
> AND WORK_ORDER.LOT_ID = REQUIREMENT.WORKORDER_LOT_ID
> AND WORK_ORDER.TYPE = REQUIREMENT.WORKORDER_TYPE
> AND (PART.FABRICATED = \'Y\' AND PART.LOW_LEVEL_CODE = :nX)
> ORDER BY TYPE, PART.ID
>
> Thanks
>
> Gary C Greenwood
>
> Centura developer. ggreenwood_at_ggtrains.com
Received on Sun Sep 05 1999 - 04:23:54 CDT