Thread: Update help

Update help

From
"Yudieg@hotmail.com"
Date:
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

Re: Update help

From
"Ligia Pimentel"
Date:
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--