Hi All,

I have two tables (sql server)

MainTable
---------
Emp_code BasicPay TotalAddition
------- -------- --------------
160       3000    200
161       4000    100

Additions Table
--------
emp_code     desc   trx_amount
----------   ---- --------
160        Bonus     100
160        Transport 100
161        Bonus      20
161        Transport 30
161        Food      50

My output report should be like this

Emp_code Basicpay Bonus transport Food TotalAddition(total of additions)
-------- --------- ------ --------- ------ -------------
160          3000    100        100 0      200
161           4000     20        30 50     100


Please suggest with this