errore con group by

[albis]

se fai una group by devi raggruppare per tutti i campi esposti

 
strSQL1="SELECT  customer_id, shipping_lastname, shipping_firstname, shipping_city, shipping_state, billing_notes, order_date FROM pazzages.orders WHERE billing_notes LIKE '%:" & strStore & ":%' GROUP BY customer_id, shipping_lastname, shipping_firstname, shipping_city, shipping_state, billing_notes, order_date ORDER BY order_date asc"