Table rows are repeating.

4 posts, 0 answers
  1. Muhammad
    Muhammad avatar
    27 posts
    Member since:
    Oct 2017

    Posted 11 Feb 2018 Link to this post

    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

     

     

     

     

     

     

     

     

     

  2. Muhammad
    Muhammad avatar
    27 posts
    Member since:
    Oct 2017

    Posted 11 Feb 2018 in reply to Muhammad Link to this post

    Hope this attached pics will help.
  3. Muhammad
    Muhammad avatar
    27 posts
    Member since:
    Oct 2017

    Posted 12 Feb 2018 Link to this post

    Here!
  4. Muhammad
    Muhammad avatar
    27 posts
    Member since:
    Oct 2017

    Posted 12 Feb 2018 Link to this post

    Here!
Back to Top