MySQL Pivot

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:

View attachment 227906

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…

MySQL Pivot