Retriving last payment date in a table with multiple vendors

[rlbSQL]

I am trying to find the last payment date made to a vendor in a table.
This table has many vendors I will need to have a line for each vendor and what thier last payment date is.

I assume it would something like this.

SELECT vendor_id, MAX(invoice_date) AS last_invoice_date
FROM MIL_VENDOR_INVOICE_PAYMENT_MT
GROUP BY vendor_id;

[rlbSQL]

I am trying to find the last payment date made to a vendor in a table.
This table has many vendors I will need to have a line for each vendor and what thier last payment date is.

I assume it would something like this.

SELECT vendor_id, MAX(invoice_date) AS last_invoice_date
FROM MIL_VENDOR_INVOICE_PAYMENT_MT
GROUP BY vendor_id;

Sorry I forgot to add - Is this correct?

This is just a part to a big report i am trying to produce.

[ronverdonk]

I am trying to find the last payment date made to a vendor in a table.
This table has many vendors I will need to have a line for each vendor and what thier last payment date is.

I assume it would something like this.

SELECT vendor_id, MAX(invoice_date) AS last_invoice_date
FROM MIL_VENDOR_INVOICE_PAYMENT_MT
GROUP BY vendor_id;

That will get the result rows you want.

Ronald :cool:

[rlbSQL]

That will get the result rows you want.

Ronald :cool:

Thank You.