title: How to GROUP BY in left join
body: <p>*</p>
  
  <p>I'm getting results like below</p>
  
  <p><code>PID</code> is repeated here, 2 rows are displaying 1 patient (john)</p>
  
  <p>I have to display only 1 row for patient_name (john)
  i have to display one row for patient john if he have multiple visits on the same date or any other date..</p>