SQL Help needed

Posted by chris allsopp on March 1, 2007, 6:56 am

Please log in for more thread options

I'm trying to zero the Reorder points and restock levels, for branch 2 and
category 546.

What's wrong with the statement below, it zero's everything for branch 2.

UPDATE Itemdynamic

SET itemdynamic.Reorderpoint ='0', itemdynamic.restocklevel ='0'

FROM itemdynamic, item

WHERE itemdynamic.storeid = '2'

AND item.categoryID = '546';

Posted by Nashat on March 1, 2007, 8:20 am

Please log in for more thread options

: quoted-printable

You didn't join Item table with ItemDynamic

UPDATE Itemdynamic
=20
SET itemdynamic.Reorderpoint =3D'0', itemdynamic.restocklevel =3D'0'
=20
FROM itemdynamic, item
=20
WHERE itemdynamic.storeid =3D '2'
AND ItemDynamic.ItemID=3DItem.ID=20
AND item.categoryID =3D '546'

> I'm trying to zero the Reorder points and restock levels, for branch 2 =

and=20

> category 546.

>=20

> What's wrong with the statement below, it zero's everything for branch =

>=20

> UPDATE Itemdynamic

>=20

> SET itemdynamic.Reorderpoint =3D'0', itemdynamic.restocklevel =3D'0'

>=20

> FROM itemdynamic, item

>=20

> WHERE itemdynamic.storeid =3D '2'

>=20

> AND item.categoryID =3D '546';

>=20

------=_NextPart_000_000D_01C75C15.2134DE50
Content-Type: text/html;
charset="windows-1256"
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=3Dwindows-1256">
<META content=3D"MSHTML 6.00.2900.3059" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT size=3D2></FONT><FONT size=3D2><FONT face=3D"Century Gothic"=20
color=3D#800000>You didn't join Item table with =
ItemDynamic</FONT></FONT></DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2></FONT> </DIV>
<DIV><FONT size=3D2><FONT face=3D"Century Gothic"><FONT =
color=3D#800000><FONT>UPDATE=20
Itemdynamic<BR> <BR> SET itemdynamic.Reorderpoint =3D'0',=20
itemdynamic.restocklevel =3D'0'<BR> <BR> FROM itemdynamic, =
item<BR> <BR>=20
WHERE itemdynamic.storeid =3D '2'<BR><FONT color=3D#ff0000>AND=20
ItemDynamic.ItemID=3DItem.ID</FONT> <BR> AND item.categoryID =3D=20
'546'</FONT><BR></FONT></FONT></DIV></FONT>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"chris allsopp" <</FONT><A=20
size=3D2>chris@emmaallsopp.plus.com</FONT></A><FONT face=3DArial =
size=3D2>> wrote=20
in message </FONT><A =
face=3DArial =
face=3DArial size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> =
I'm trying to=20
zero the Reorder points and restock levels, for branch 2 and <BR>> =
category=20
546.<BR>> <BR>> What's wrong with the statement below, it zero's=20
everything for branch 2.<BR>> <BR>> UPDATE Itemdynamic<BR>> =
<BR>>=20
SET itemdynamic.Reorderpoint =3D'0', itemdynamic.restocklevel =
=3D'0'<BR>>=20
<BR>> FROM itemdynamic, item<BR>> <BR>> WHERE =
itemdynamic.storeid =3D=20
'2'<BR>> <BR>> AND item.categoryID =3D '546';<BR>>=20
<BR>></FONT></BODY></HTML>

------=

Posted by chris allsopp on March 1, 2007, 8:36 am

Please log in for more thread options

: quoted-printable

Thanks Nashat, you've come to my rescue again. I'm learning though !

thanks
Chris
You didn't join Item table with ItemDynamic

UPDATE Itemdynamic
=20
SET itemdynamic.Reorderpoint =3D'0', itemdynamic.restocklevel =3D'0'
=20
FROM itemdynamic, item
=20
WHERE itemdynamic.storeid =3D '2'
AND ItemDynamic.ItemID=3DItem.ID=20
AND item.categoryID =3D '546'

> I'm trying to zero the Reorder points and restock levels, for branch =
2 and=20
> category 546.
>=20
> What's wrong with the statement below, it zero's everything for =
branch 2.
>=20
> UPDATE Itemdynamic
>=20
> SET itemdynamic.Reorderpoint =3D'0', itemdynamic.restocklevel =3D'0'
>=20
> FROM itemdynamic, item
>=20
> WHERE itemdynamic.storeid =3D '2'
>=20
> AND item.categoryID =3D '546';
>=20
>
------=_NextPart_000_02AE_01C75C06.AAFC0230
Content-Type: text/html;
charset="windows-1256"
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=3Dwindows-1256">
<META content=3D"MSHTML 6.00.6000.16414" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>
<DIV><FONT size=3D2>Thanks Nashat, you've come to my rescue again.  =
I'm=20
learning though !</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>thanks</FONT></DIV>
<DIV><FONT size=3D2>Chris</FONT></DIV></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Nashat" <<A=20
wrote in=20
message <A=20
=
@TK2MSFTNGP03.phx.gbl</A>...</DIV>
<DIV><FONT size=3D2></FONT><FONT size=3D2><FONT face=3D"Century =
Gothic"=20
color=3D#800000>You didn't join Item table with =
ItemDynamic</FONT></FONT></DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2></FONT> </DIV>
<DIV><FONT size=3D2><FONT face=3D"Century Gothic"><FONT =
color=3D#800000><FONT=20
size=3D+0>UPDATE Itemdynamic<BR> <BR>SET itemdynamic.Reorderpoint =
=3D'0',=20
itemdynamic.restocklevel =3D'0'<BR> <BR>FROM itemdynamic,=20
item<BR> <BR>WHERE itemdynamic.storeid =3D '2'<BR><FONT =
color=3D#ff0000>AND=20
ItemDynamic.ItemID=3DItem.ID</FONT> <BR>AND item.categoryID =3D=20
'546'</FONT><BR></FONT></FONT></DIV></FONT>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"chris allsopp" <</FONT><A=20
size=3D2>chris@emmaallsopp.plus.com</FONT></A><FONT face=3DArial =
size=3D2>> wrote=20
in message </FONT><A =
face=3DArial =
face=3DArial size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> =
I'm trying to=20
zero the Reorder points and restock levels, for branch 2 and <BR>> =
category=20
546.<BR>> <BR>> What's wrong with the statement below, it zero's =

everything for branch 2.<BR>> <BR>> UPDATE Itemdynamic<BR>> =
<BR>>=20
SET itemdynamic.Reorderpoint =3D'0', itemdynamic.restocklevel =
=3D'0'<BR>>=20
<BR>> FROM itemdynamic, item<BR>> <BR>> WHERE =
itemdynamic.storeid =3D=20
'2'<BR>> <BR>> AND item.categoryID =3D '546';<BR>> =
<BR>></FONT>=20
</BLOCKQUOTE></BODY></HTML>

------=