Hi$!$ Im currently working in a query for my database class $.$ Were using you data from a health clinic for clients who has a first time assessment for a procedure and need a reevaluation within $6$ months. Right now Im getting a lot of duplication $($see the photos below$)$ because every time an assessment is done, a new row of data is created in the table. I would like to combine the rows of data into one row Ive attched a photonof the duplication issue

Query: SELECT cd$.$cid $,$ cd$.$client$\_$name $,$ cd$.$attendingDoctor $,$ assess.firstAssessment $,$ assessment.sixMonthAssessment $,$ discharge.dischargeDate From clientData cdInner join assessment$\_$data assess ON assess.cid $=$ cd$.$cid Left join discharge$\_$data discharge ON

discharge.cid $=$ cd$.$cid