Path: utzoo!utgpu!water!watmath!clyde!att!osu-cis!tut.cis.ohio-state.edu!mailrus!ncar!ames!lll-tis!daitc!jkrueger@daitc.daitc.mil
From: jkrueger@daitc.daitc.mil (Jonathan Krueger)
Newsgroups: comp.databases
Subject: Re: replace in SQL
Keywords: replace, SQL
Message-ID: <213@daitc.daitc.mil>
Date: 26 Oct 88 05:51:38 GMT
References: <226@ur-cc.UUCP> <1272@cod.NOSC.MIL>
Sender: news@daitc.daitc.mil
Reply-To: jkrueger@daitc.daitc.mil (Jonathan Krueger)
Organization: Defense Applied Information Technology Center
Lines: 13
In-reply-to: dberg@cod.NOSC.MIL (David I. Berg)

In article <1272@cod.NOSC.MIL>, dberg@cod (David I. Berg) writes:
>update result set score = (select test from new where new.id = score.id)
>
>-- 

Which SQL is executing this?

And has its vendor explained that ANSI compliant SQL will not do this?

-- Jon

Ref to Date, "A Guide to the SQL Standard".
--