MYSQL查询 - 使用另一个表中的几个ID来汇总项目

I have 2 tables as indicated. I am able to SUM the qty_sold for each item_id from the item_transactions table. In a separate column I would like to SUM the qty_sold for all previous editions of that item from the i_multiple_int_attributes table (some have up to 4 previous editions). Can someone point me in the right direction?I have 2 tables as indicated. I am able to SUM