Oracle SQL DISTINCT HELP!!

From: Gary C. Greenwood <ggreenwood_at_ggtrains.com>
Date: Fri, 27 Aug 1999 12:14:58 -0700
Message-ID: <rsde4mruj7122@corp.supernews.com>

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 Fri Aug 27 1999 - 14:14:58 CDT