Could someone help me in writing the query to find the vendor ID, vendor number, vendor name, vendor site code, Created Date, Last Update Date, last invoice date, last payment date, total # of invoices and total $ amount of invoices for each supplier. All these should be group by the vendor ID. Means all the vendor ids in the report should be unique. Please help. 1) How do I find the last payment date 2) How do I find supplier_catagory? 3) As I have to use sum(invoice_amount), count(invoice_amount), max(payment_date) which point to 3 different tables, I am not sure how to use "group by" based on the Vendor_id alone while I select lot of fields from different table. Could you please help me with this?