5 Replies Latest reply: Nov 15, 2017 3:47 AM by Shahzad Ahsan RSS

    How to count number of transactions in table

    Shahzad Ahsan

      Hello Everyone

      I have two tables; Customer & Invoice

      Customer table has 1000 records like this

      CustomerIdCustomerName
      1A
      2B
      3C
      4D
      5E

       

      Invoice Table contains 100 records like this

      InvoiceIdCustomerIdAmount
      111000
      23500
      35600
      41200
      51100
      63600

       

      I want all 100 records from Invoice table like this

      CustomerIdCustomerNameInvoiceCountTotalAmount
      1A31300
      3C21100
      5E1600