Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. logidude90

    3 tables query for sum and count

    Thanks PHV, It's really appreciated sorry I didn't reply sooner but I was away for the last couple of days. It seems like it would do what I want it to do, will give it a shot.
  2. logidude90

    3 tables query for sum and count

    Yeah select count(DISTINCT) seems like something that would fix my problem. SELECT CUSTOMER_TYPE.TypeDescription, Count(CUSTOMER.customerID) AS [NbCustomer], Sum(INVOICES.AmmountBilled) AS [Total ammount for type] FROM CUSTOMER_TYPE INNER JOIN (CUSTOMER INNER JOIN INVOICES ON...
  3. logidude90

    3 tables query for sum and count

    Hi everyone, I've been trying to write this query for a little while now and just can't get it to work. The simplified table schema looks something like this: CUSTOMER -------------- customerID customerName customerType INVOICES -------------- customerID AmmountBilled CUSTOMER_TYPE...

Part and Inventory Search

Back
Top