Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 67C35475E84 for ; Tue, 3 Sep 2002 12:38:22 -0400 (EDT) Received: from mail1.forsingles.com (unknown [216.52.172.68]) by postgresql.org (Postfix) with ESMTP id C2781475C8B for ; Tue, 3 Sep 2002 12:38:21 -0400 (EDT) Received: from yudie (216.52.172.78 [216.52.172.78]) by mail1.forsingles.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id RBZN7HAA; Tue, 3 Sep 2002 11:38:32 -0500 Message-ID: <001a01c25368$5b374c10$8a01a8c0@yudie> From: "Yudie@axiontech.com" To: Subject: Update Help Date: Tue, 3 Sep 2002 11:38:30 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0015_01C2533E.6D792990" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/11 X-Sequence-Number: 9288 This is a multi-part message in MIME format. ------=_NextPart_000_0015_01C2533E.6D792990 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Let say I have 2 Product table, both of them has columns ProductID and Price What is the update command if I want to update all Prices of first table to= be equal with Price in second table? Please Help. Yudie ------=_NextPart_000_0015_01C2533E.6D792990 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

Let say I have 2 Product table, both of th= em has=20 columns ProductID and Price

What is the update command if I want to up= date=20 all Prices of first table to be equal with Price in second=20 table?

Please Help.

Yudie

------=_NextPart_000_0015_01C2533E.6D792990--