Group By子句导致错误

该 领域 你 GROUP BY
，你需要或者使用聚合

sum

max

SELECt   p.FirstName        ,p.LastName        ,pa.EndDate        ,pr.PurchaseDate        ,pr.SerialNumber        ,pr.CatalogPrice        ,v.PlateNumber        ,v.FirstCirculationDate        ,v.FirstDrivingTax        ,v.UsualDrivingTaxFROM     bm_ProductAllocations AS paINNER JOIN bm_Persons AS p ON pa.Id_Person = p.Id_PersonINNER JOIN bm_Products AS pr ON pa.Id_Product = pr.Id_ProductINNER JOIN bm_Vehicles AS v ON pr.Id_Product = v.Id_ProductGROUP BY pa.Id_Product        ,p.FirstName        ,p.LastName        ,pa.EndDate        ,pr.PurchaseDate        ,pr.SerialNumber        ,pr.CatalogPrice        ,v.PlateNumber        ,v.FirstCirculationDate        ,v.FirstDrivingTax        ,v.UsualDrivingTax;