OK, how about this one. (I know I'm going to kick myself when I learn the solution). I have 2 tables, clients and orders. I'm trying to generate a sales report for our rep. I need to display several generic columns from customers along with the date of the customer's last order. If there are no orders for the customer in the system, then I still want the customer record to appear. I've been able to show all customers with orders using a GROUP BY, but not all customers with no orders placed. Also, my statement (using MAX(T2.OrderDate) ) generates several instances of the customer record. I know I'm thinking about this problem back-assward. Where am I going wrong? Thanks, Dan
