Items
ItemId   ItemName
444      Item-1
555      Item-2
666      Item-3

Locations
LocationId  LocationName
12           Loc1
13           Loc2
14           Loc3
15           Loc4
17           Loc5


Stock
Id          ItemId       LocationId    stock
1           444           12            2
2           444           13            15
3           555           14            20
4           666           15            14
5           666           17            12

Result Table
ItemName        LocationName        stock
Item-1            Loc2               15
Item-2            Loc3               20
Item-3            Loc4               14

Select I.ItemName,L.LocationName,S.stock from Items I
inner join Stock S on
I.ItemId = S.ItemId
inner join Locations L on
S.LocationId = L.LocationId