Received: from bvsdps.com ([199.45.32.25]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA66958 for ; Wed, 16 Jun 1999 14:35:33 -0400 (EDT) (envelope-from mlundquist@bvsdps.com) Received: from [172.16.200.154] (199.45.32.20) by bvsdps.com with ESMTP (Eudora Internet Mail Server 2.0.1); Wed, 16 Jun 1999 14:33:58 -0400 X-Sender: mlundquist@macmail.bvsdps.com Message-Id: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Wed, 16 Jun 1999 14:35:26 -0400 To: pgsql-sql@postgreSQL.org From: Mark Subject: Update with two tables?? I am trying to update table A with data from table B. I thought I could do something like: UPDATE A SET A.name = B.name WHERE A.id = B.id FROM B but alas, this does not work. Anyone have an idea of how I can do this? -Mark ----------------------------------------------------------------- Mark Lundquist mlundquist@bvsdps.com -----------------------------------------------------------------