Set Analysis

[ramasaisaksoft]

hi Friends/Experts,

need set analysis expression for comparing 4 columns like

Tab 1:-  1)item_no,2)item_name 3)Item_Rank

Tab2:- 1)item_num,2)item_naming 3)Item_Rank 4)item_cost

now i want expression for 

sum(item_cost) where item_no=item_num & item_name=item_naming

aggr(if((item_no=item_num and item_name=item_naming),sum(item_cost)) , ( item_Rank))