This is a migrated thread and some comments may be shown as answers.

Table rows are repeating.

3 Answers 101 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Muhammad
Top achievements
Rank 1
Muhammad asked on 12 Feb 2018, 05:44 AM

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

 

 

 

 

 

 

 

 

 

3 Answers, 1 is accepted

Sort by
0
Muhammad
Top achievements
Rank 1
answered on 12 Feb 2018, 05:53 AM
Hope this attached pics will help.
0
Muhammad
Top achievements
Rank 1
answered on 12 Feb 2018, 06:00 AM
Here!
0
Muhammad
Top achievements
Rank 1
answered on 12 Feb 2018, 06:00 AM
Tags
General Discussions
Asked by
Muhammad
Top achievements
Rank 1
Answers by
Muhammad
Top achievements
Rank 1
Share this question
or