Re: [GENERAL] INNER JOIN .... USING in an UPDATE

2008-11-18 Thread Richard Huxton
Webb Sprague wrote: Hi all, (Version 3.5.5) I'd upgrade - version 3.5.5 doesn't actually exist :-) I have tried to figure this out, but the docs, google, and my all imagination fail me. I want to use a join clause with a using list in an update statement. The following works, but it uses

[GENERAL] INNER JOIN .... USING in an UPDATE

2008-11-17 Thread Webb Sprague
Hi all, (Version 3.5.5) I have tried to figure this out, but the docs, google, and my all imagination fail me. I want to use a join clause with a using list in an update statement. The following works, but it uses the WHERE version of a join: update new_pivoted_table a set 2008-11-10 =