Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

Posted on 2003-10-23
Medium Priority
646 Views
I have 2 tables:

Table 1
OrderID
ProductID
ItemQuantity
ItemName
ItemCost

Table 2
SessionID
ProductID
ItemQuantity

What I am trying to do is update Table1.ItemQuantity with values of Table2.ItemQuantity where their productIDs are equal.

0
Question by:zagnutts
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 75

Assisted Solution

Anthony Perkins earned 500 total points
ID: 9611545
Update Table1
Set ItemQuantity = Table2.ItemQuantity
From Table1
Inner Join Table2 On Table1.ProductID = Table2.ProductID

Also, please maintain this old open question:
http://www.experts-exchange.com/Web/Web_Languages/ASP/Q_20725832.html

Thanks,
Anthony
0

LVL 15

Accepted Solution

namasi_navaretnam earned 500 total points
ID: 9611570
What  is the PK for Table1, Table2?

In the scenario illustrated below, should the ItemQuantity be updated with value 5 or 6?

Table1
Product1D ItemQuantity
===============
1             4
2             ?

Table2
Product1D ItemQuantity
===============
1             4
2             5
2             6

SQL you are asking for is listed below. But the update may be incorrect?

Update Table1
Set      ItemQuatity = Table2.ItemQuantity
FROM Table2
WHERE Table1.ProductId = Table2.ProductId

HTH

Namasi Navaretnam

0

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses
Course of the Month9 days, 1 hour left to enroll