i have 2 table table 1 stock_nbr , cont_id, qty_order 001 A001 10 002 A002 20 002 A001 20 Table 2 Stock_nbr Total Order 001 10 002 40 How to join this two table and show in ireport in below format Stock_nbr, A001,A002 ,Total_Order 001, 10, 0 ,10 002, 20, 20,40