complex (for me) order by

[Cathy and Dave]

SQL 2k.
I have 2 tables
    1. CLIENTS, which contains columns - ClientID, ClientName
    2. PRODUCTS, which contains columns - ProductID, ProductName

In a many-to-many relationship via a third table
    3. ORDERS, containing columns - ClientID, ProductID  

How do I retrieve a list of clients in alphabetical ProductName, ClientName order?

    TIA for all and any help,
        Dave

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---