Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 75E94476652 for ; Tue, 3 Sep 2002 12:19:50 -0400 (EDT) Received: from hotmail.com (oe50.law3.hotmail.com [209.185.240.218]) by postgresql.org (Postfix) with ESMTP id 25949475EA4 for ; Tue, 3 Sep 2002 12:19:04 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 3 Sep 2002 09:19:09 -0700 X-Originating-IP: [216.52.172.78] From: "Yudieg@hotmail.com" To: Subject: Update help Date: Tue, 3 Sep 2002 11:19:18 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00AA_01C2533B.BE837FA0" 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 Message-ID: X-OriginalArrivalTime: 03 Sep 2002 16:19:09.0609 (UTC) FILETIME=[A2182990:01C25365] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/21 X-Sequence-Number: 9298 This is a multi-part message in MIME format. ------=_NextPart_000_00AA_01C2533B.BE837FA0 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_00AA_01C2533B.BE837FA0 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_00AA_01C2533B.BE837FA0--