Caclulating Count of unique values

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Roy Goldhammer (roygoldh_at_hotmail.com)
Date: 12/16/04

  • Next message: Allen Browne: "Re: Caclulating Count of unique values" 
    Date: Thu, 16 Dec 2004 09:29:05 +0200

    Hello there

    I have order table

    In the order table i have clitntID and OrderID

    Each client have more then one order

    On the query i need to get total money of all orders and total clients.

    when i do it only with Orders table and Count function i get all orders and
    not all clients

    is there a way to get only clients?

  • Next message: Allen Browne: "Re: Caclulating Count of unique values"
    • Quantcast