Reikia grazinti lenteleje kiek prekiu iejo ir kiek isejo. Problema kaip 
padaryti "join" hin su hout pagal Location lauka jau gavus rezultata. 
Tiesiog join negaliu rasyti, nes hin arba hout puseje location skaicius gali 
nesutapti ir join neivyks.select i.ArtCode,i.Name, hin.ArtCode,hin.Location, 
sum(hin.`Qty`)as QtyIn,sum(hin.`TotCostPrice`) as AmountIn,
hout.Location,sum(hout.`Qty`)as QtyOut,sum(hout.`TotCostPrice`) as AmountOut
from Items i
join itemhist hin on hin.ArtCode=i.ArtCode
join itemhist hout on hout.ArtCode=i.ArtCode

where hin.Qty>0 and
hout.Qty<0 and
hin.Location=hout.Location /* sita eilute netinka */
group by hin.ArtCode,hin.Location