F
Fred
I am trying to create a query that returns name and address data for a
customer and date, type, and amount data from the last transaction for that
customer.
The max(transaction date) function returns the last date, but if I add other
fields form the transaction table, I return too many rows.
How do I limit the query to just the data from the last transaction?
customer and date, type, and amount data from the last transaction for that
customer.
The max(transaction date) function returns the last date, but if I add other
fields form the transaction table, I return too many rows.
How do I limit the query to just the data from the last transaction?