7 Replies Latest reply: Mar 14, 2012 11:13 AM by Sandeep Gandhi, Consultant RSS

    Vendor ID, Last Update Date, Invoice Details - Query

      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.