title: Error related to only_full_group_by when executing a query in HeidiSQL
body: <p>I want to create a view in my DB, and below are my code and Error message</p>
  
  <blockquote>
    <p>Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ucarer_server.ord_order.request_patient_id" which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by</p>
  </blockquote>
  
  <p>and also, I've checked the answer on stackoverflow, too
  Here's the link</p>
  
  <p><a href="https://stackoverflow.com/questions/34115174/error-related-to-only-full-group-by-when-executing-a-query-in-mysql">Error related to only_full_group_by when executing a query in MySql</a></p>
  
  <p>But, still can't work for me...
  Can anyone tell me where can I fix?</p>
  
  <pre><code>select
     ord_order.`request_patient_id`,
     ord_order.`order_id`,
     ord_order.`bundle_id`,
     gvr_caregiver.`surname` as gvr_surname,
     ord_order.`gvr_response_datetime` as 'gvr_response_datetime',
     usr_user.user_id,
     ord_order.`order_status_code_abbr`,
     gvr_caregiver.`first_name` as gvr_first_name,
     IFNULL(ord_order.`bundle_number`, ord_order.`order_number`) as bundleOrOrderNumber,
     ord_order.order_status_last_update_datetime
  from ord_order
  left join gvr_caregiver on ord_order.srv_caregiver_id = gvr_caregiver.caregiver_id
  left join usr_user on usr_user.patient_id = ord_order.request_patient_id
  group by bundleOrOrderNumber;
  </code></pre>