select p.productname, c.clientname from (products as p inner join orders as o on p.productid = o.productid) inner join clients as c on o.clientid = c.clientid
Sunday, March 14, 2004, 5:48:27 PM, you wrote:
Cathy> SQL 2k.
Cathy> I have 2 tables
Cathy> ��� 1. CLIENTS, which contains columns - ClientID, ClientName
Cathy> ��� 2. PRODUCTS, which contains columns - ProductID, ProductName
Cathy> In a many-to-many relationship via a third table
Cathy> ��� 3. ORDERS, containing columns - ClientID, ProductID��
Cathy> How do I retrieve a list of clients in alphabetical
Cathy> ProductName, ClientName order?
Cathy> ��� TIA for all and any help,
Cathy> ��������Dave
Cathy>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
