[SQL] Re: order of multiple assignments in UPDATE

2001-04-29 Thread Ossie J. H. Moore
While I'm not sure specificly which order they will be determined in, it has no effect on what the value of "c1" will be. The value of "c1" will be 10 minus the value of "c2" where "c2" equals the value it was before the update occurred. For exmple... 1. Assume you create the following table...

Re: [SQL] using top-level aggregate values in subqueries

2001-04-26 Thread Ossie J. H. Moore
Subject: Re: [SQL] using top-level aggregate values in subqueries Date: Mon, 23 Apr 2001 23:24:48 -0500 From: Ossie J. H. Moore <[EMAIL PROTECTED]> To: "Thomas F. O'Connell" <[EMAIL PROTECTED]> I'm a little unclear on what you are trying to do here so I'll