Re: Help! Sybase SQL to Oracle...
From: Charles Dye <cdye_at_dnt.dialog.com>
Date: 1996/01/17
Message-ID: <4dhnrr$lid_at_iserv.dnt.dialog.com>#1/1
Date: 1996/01/17
Message-ID: <4dhnrr$lid_at_iserv.dnt.dialog.com>#1/1
KJ,
UPDATE TOTAL_COMP_DATABASE T
SET UP_DUP = Y
WHERE EXISTS (SELECT EMPLID FROM PS_UPLOAD U WHERE U.EMPLID = T.TEMPLID)
;
Regards,
Charles_Dye_at_corp.dialog.com
In article <4dgmfp$q44_at_bigboote.WPI.EDU>, kibwe_at_wpi.edu (KJ) writes:
> Here is the Sybase SQL:
>
> UPDATE TOTAL_COMP_DATABASE t SET UP_DUP = 'Y' WHERE (SELECT COUNT(*) FROM
> PS_UPLOAD1 U WHERE U.EMPLID = T.EMPLID) > 1
Received on Wed Jan 17 1996 - 00:00:00 CET