Hello:

I'm trying to create a sql statement (or series of) that would allow me to identify what vendor record has the max(invoice_date) and max(invoice_amount). Not the aggregate values all of venders. I need to get the max(invoice_amount) because we can have mulitple records with the same invoice date. Invoice number may not be unique in this situation.

I was able to create one sql statement with a subquery to return max(invoice_date) for each vender, but having two max requirements got be bogged down.


Regards,

Steve