Re: Update help

From: "Ligia Pimentel" <pimentel_ligia(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Update help
Date: 2002-09-05 17:29:47
Message-ID: al885a$1t1h$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

update table1 set price = table2.price
where table1.productId = table2.productId;

(Of course, both tables must have a different name).

:)
Ligia

""Yudieg(at)hotmail(dot)com"" <yudieg(at)hotmail(dot)com> wrote in message
news:OE50r7MoNYXRRS6HtHO00000811(at)hotmail(dot)com(dot)(dot)(dot)
> 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
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html;
charset=3Diso-8859-1">
> <META content=3D"MSHTML 5.50.4916.2300" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>Let say I have 2 Product table, both of
th=
> em has=20
> columns ProductID and Price</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>What is the update command if I want to
up=
> date=20
> all&nbsp;Prices of first table to be equal with Price in second=20
> table?</FONT></DIV>
> <DIV>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>Please Help.</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>Yudie</FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_00AA_01C2533B.BE837FA0--

In response to

  • Update help at 2002-09-03 16:19:18 from Yudieg@hotmail.com

Browse pgsql-sql by date

  From Date Subject
Next Message mallah 2002-09-05 18:49:22 Re: new calculated column
Previous Message andres javier garcia garcia 2002-09-05 16:58:34 new calculated column