Re: Simple SQL question

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 23 Jun 2005 08:20:10 -0700
Message-ID: <1119540010.517052.261030@g43g2000cwa.googlegroups.com>

Dean, if subquery S returns on a sinle value and is not coordinated then it could be ran as a separate SQL statment feeding its result into a variable and the bind variable could then be referenced in the update statement, but in general no you cannot substitute a variable for S. You will have to code S as necessary.

An example might allow someone to make more specific suggestions that would be of more value to you than my reply.

HTH -- Mark D Powell -- Received on Thu Jun 23 2005 - 10:20:10 CDT