Path: utzoo!utgpu!water!watmath!clyde!att!rutgers!apple!bionet!agate!helios.ee.lbl.gov!nosc!cod!dberg
From: dberg@cod.NOSC.MIL (David I. Berg)
Newsgroups: comp.databases
Subject: Re: replace in SQL
Keywords: replace, SQL
Message-ID: <1282@cod.NOSC.MIL>
Date: 27 Oct 88 20:14:26 GMT
References: <226@ur-cc.UUCP> <1272@cod.NOSC.MIL> <445@cullsj.UUCP> <215@daitc.daitc.mil>
Organization: Naval Ocean Systems Center, San Diego
Lines: 19

In article <215@daitc.daitc.mil>, jkrueger@daitc.daitc.mil (Jonathan Krueger) writes:
> In article <1278@cod.NOSC.MIL>, dberg@cod (David I. Berg) writes:
> >update result set score = (select test from new where result.id = new.id)
> >  where result.id in (select id from new)
> 
> What SQL is executing this?  Has its vendor informed you that such SQL
> is not standard and hence will not execute on ANSI compliant SQL DMBS?
> 

This statement is being executed by INFORMIX SQL Version 2.1.  I will
gladly, upon request, provide a complete SQL script to create the tables 
in question with the values suggested by Mr. Gupta and this update 
statement to achieve the desired result. 

-- 
David I. Berg (dberg@nosc.mil)
GENISYS Information Systems, Inc., 4250 Pacific Hwy #118, San Diego, CA 92110
MILNET: dberg@nosc.mil
UUCP:   {akgua decvax dcdwest ucbvax}!sdcsvax!noscvax!dberg