joining item master to item Location issue

[awholtsIT]

SQL 2005

Table A (Item Master) Table B (Item Location)

There is 1 record for every item in the item master TABLE A.
There are 3 records for every item in the item location table, TABLE B.

I want to join the (2) tables and have the results be just 1 record per item where the quantities in each location from Table B are summed.

ex: Table A.Item = ABC
Table B.Item= ABC, Location 1 has qty of 5
B.Item= ABC Location 2 has qty of 5
B.Item= ABC Location 3 has qty of 1

I want the results to have the following;

Item QTY
ABC 11

My results, no matter what type of join operation I use, has
(3) records. one for each location.

Appreciate any help with this query.

Thanks,

Andrew

 

[markros]

Select Items.ItemID, sum(Location.Qty) as TotalQty from Items 
inner join Locations on Items.ItemID = Location.ItemID
group by Items.ItemID

 

[awholtsIT]

That was it.

Many thanks for your help.

Andrew

 

[markros]

You're welcome