INTERSECT
From: M. Thomas Groszko <mgroszko_at_sirus.com>
Date: Tue, 12 May 1998 21:00:50 -0500
Message-ID: <6jarf9$fmo$1_at_news10.ispnews.com>
I am porting an application from Oracle to Sybase. Does anybody here know the Sybase for Intersect?
INTERSECT
SELECT PART.MFGR_CODE, PART_NUMBER,
PART_DESC, ALTPART.ALT_NUM, ALT_DESC
FROM PART (MRU), ALTPART (MRU), PARTNOUN (MRU) WHERE PART.ALT_NUM *= ALTPART.ALT_NUM
AND PARTNOUN.PART_NUM = PART_NUMBER
AND PARTNOUN.MFGR_CODE = PART.MFGR_CODE
AND NOUN = 'BOLT' Received on Wed May 13 1998 - 04:00:50 CEST
Date: Tue, 12 May 1998 21:00:50 -0500
Message-ID: <6jarf9$fmo$1_at_news10.ispnews.com>
I am porting an application from Oracle to Sybase. Does anybody here know the Sybase for Intersect?
SELECT PART.MFGR_CODE, PART_NUMBER,
PART_DESC, ALTPART.ALT_NUM, ALT_DESC
FROM PART (MRU), ALTPART (MRU), PARTNOUN (MRU)
WHERE PART.ALT_NUM *= ALTPART.ALT_NUM
AND PARTNOUN.PART_NUM = PART_NUMBER
AND PARTNOUN.MFGR_CODE = PART.MFGR_CODE
INTERSECT
SELECT PART.MFGR_CODE, PART_NUMBER,
PART_DESC, ALTPART.ALT_NUM, ALT_DESC
FROM PART (MRU), ALTPART (MRU), PARTNOUN (MRU) WHERE PART.ALT_NUM *= ALTPART.ALT_NUM
AND PARTNOUN.PART_NUM = PART_NUMBER
AND PARTNOUN.MFGR_CODE = PART.MFGR_CODE
AND NOUN = 'BOLT' Received on Wed May 13 1998 - 04:00:50 CEST