i have 3 table


table tb_mesure = ident,code,descr
table tb_item = ident,code,descr
table tb_item_in = ident , ident_item,ident_mesure,qty



i want to get the sum of the qty(tb_item_in) with the code(tb_item) and the descr(tb_mesure)




how can i make the select for sql server


thanks