Recent content by MaxHewitt
-
M
Multi-level GROUP BY clause is not allowed in a subquery
I ran into the same kind of problem with this and resolved it quite simply by doing the following: Original Query: SELECT Customers.CustomerName, Invoices.InvoiceNumber, Invoices.Comment, Invoices.InvoiceDate, Invoices.InvoiceAmount, (SELECT Max([PaymentDate]) FROM PaymentLineItems WHERE...