Help

[alvintkl]

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      

  

[alvintkl]

Can any one help??