Hi ..
I have a query to select Item points from char:
Its work well... But i want add also info from: _InventoryForAvatar where slot = 4 (devil spirit +)Quote:
select SUM(_Items.OptLevel) as ItemPoints
from _Char
right join _Inventory ON _Inventory.CharID =_Char.CharID
right join _Items ON _Items.ID64 in (_Inventory.ItemID)
where _Inventory.Slot between 0 and 12 and _Char.CharID = @CharID
Who can help me сombine a query?
