Ciao a tutti! Ho un problema: devo selezionare vari recordo. Ci sono però recod doppi. IO vorrei quello con la data più recente. Ho provato ad usare max ma mi dice:
Server: Msg 8118, Level 16, State 1, Line 4
Column 'prodotti.Codice' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.
Server: Msg 8118, Level 16, State 1, Line 4
Column 'prodottiprezzi.CodiceProdotto' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.
Server: Msg 8118, Level 16, State 1, Line 4
Column 'prodottiprezzi.NodoPrezzo' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.
Server: Msg 8118, Level 16, State 1, Line 4
Column 'fornitori.RagioneSociale' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.
Server: Msg 8118, Level 16, State 1, Line 4
Column 'prodottiprezzi.Prezzo' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.