Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAE9bkm13344 for ; Wed, 14 Nov 2001 04:37:47 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fAE9Rt646228 for pgsql-sql@postgresql.org; Wed, 14 Nov 2001 04:27:55 -0500 (EST) (envelope-from news) From: Carl van Tast X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Is this a bug? Date: Wed, 14 Nov 2001 10:28:38 +0100 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 24 Message-ID: <2od4vtsmsb9ifod31ice97busd1qhcjb4f@4ax.com> References: <9sqakt$op1$1@news.tht.net> <73t1vtk61pcsob9pa0p32a9eou3a31tolh@4ax.com> <9srnih$10qq$1@news.tht.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: scrappy@hub.org X-Newsreader: Forte Agent 1.8/32.548 To: pgsql-sql@postgresql.org X-Archive-Number: 200111/185 X-Sequence-Number: 5569 On Tue, 13 Nov 2001 10:07:56 -0800, "Jack Gao" wrote: >"Carl van Tast" wrote in message >news:73t1vtk61pcsob9pa0p32a9eou3a31tolh@4ax.com... >> Update tblUserConfig >> Set Value = '1' >> From tblConfigItem As b >> Where tblUserConfig.ItemID = b.ID >> And b.Scope = 3 >> And tblUserConfig.UserID = 1 >> And b.Name = 'UserClassID'; > >So, I can't use JOIN in UPDATE? You cannot use explicit JOIN syntax. But you use joins implicitly. Just construct your WHERE clause as if you had tblUserConfig in your FROM clause. > >Thanks for your reply > >Jack Kind regards Carl van Tast