errore con group by

[yro]

qesta al query:

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 ORDER BY order_date asc"

questo l'errore:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Column 'piazzaerbeges.orders.shipping_lastname' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

come mai secondo voi??

:master: