update table1 set price = table2.price where table1.productId = table2.productId;
(Of course, both tables must have a different name). :) Ligia ""[EMAIL PROTECTED]"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 Prices of first table to be equal with Price in second=20 > table?</FONT></DIV> > <DIV> </DIV> > <DIV><FONT face=3DArial size=3D2>Please Help.</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>Yudie</FONT></DIV></BODY></HTML> > > ------=_NextPart_000_00AA_01C2533B.BE837FA0-- ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
