Table rows are repeating.

[Muhammad]

Hi there,

Hope everybody will be doing fine. I am stuck at a very unclear problem. I am trying to display the data in a table for a specific employee. The problem is that table is showing data exactly for how many times it is in database but the query is written in that way that a record will be repeated because of JOINS I guess. I want to show the row single time for an employee but it is repeating.
My structure is like this.

Employee Name    Addition                     Deduction
Ahmad Ali              Bonus                        Leave
Ahmad Ali              Timely Submission    Leave

 

I want it to be like this


Employee Name    Addition                     Deduction
Ahmad Ali              Bonus                        Leave
Ahmad Ali              Timely Submission    

 

I am using 2 tables in the detail section one for addition and one for deduction because these are two separate tables in the database as well.
Hoping to get a prompt reply. This is urgent please help.

Regards, Asim

 

 

 

 

 

 

 

 

 

[Muhammad]

Hope this attached pics will help.

[Muhammad]

Here!

[Muhammad]

Here!