This discussion is archived
7 Replies Latest reply: Mar 14, 2012 9:13 AM by Sandeep Gandhi, Consultant RSS

Vendor ID, Last Update Date, Invoice Details - Query

923674 Newbie
Currently Being Moderated
For each Supplier, we would like to know the vendor ID, vendor number, vendor name, vendor site code, Created Date, Last Update Date, last invoice date, last payment date, total number of invoices and total $ amount of invoices for each supplier.
1) How do i find the last payment date and supplier catagory?
2) 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?
3) Please help me to get this query fixed.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points