On Thu, May 26, 2011 at 1:40 PM, Rick Genter <rick.genter@gmail.com> wrote:
>
> The UPDATE statement when multiple tables are involved always drives me nuts.
> I think what you need to do is remove all of the "old." from the SET clause and use "triple." in the WHERE clause
insteadof "old." - and remove the old table alias from the UPDATE.
This worked. Thanks very much
--
Andy