Thread: Update help
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
update table1 set price = table2.price where table1.productId = table2.productId; (Of course, both tables must have a different name). :) Ligia ""Yudieg@hotmail.com"" <yudieg@hotmail.com> wrote in message news:OE50r7MoNYXRRS6HtHO00000811@hotmail.com... > 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--