Hi Mate, I need some help here, i want to create a Pivot table to display the output i want. here is my database table: I want it to display clientid | lastname | firstname | Job 1 | Amount | Job 2 | Amount 283641 Rey Ann 04-18-2017 268.00 07-11-2016 708.00 Where Job Columns are dynamic which holds the date of the job and the amount is also dynamic that holds the amount of job. Can you help me create a PIVOT out of the table i presented and the output i need. Thank you Neil Job # is dynamic as it holds the date of the job a client has, so if client x has 4 jobs, it will display 4 Jobs and Amount columns. and if the client has only 2 Jobs, it will display 2 Jobs and Amount and two Jobs will be 0
https://stackoverflow.com/questions/16353180/mysql-pivot-view Check out the answer from hims056. That's the direction I would go with this.