I'm trying to do a query that I don't even know is possible. I'd like to get all of my customers, and the LAST product they purchased in a result set. I don't want multiple products for each customer in the results because of the size of the result set. Table A is a customer table. It looks something like this: CustID, CustName 01, Bill Knight 02, Bob Harrington 03, Doyle Brunson Table B is a product table that looks something like this: CustID, ProductID, ProductName, DatePurchased 01, 01, Pencil, 08/01/04 01, 03, Chalk, 08/03/04 01, 02, Eraser, 08/07/04 02, 03, Chalk, 08/02/04 03, 02, Eraser, 08/04/04 03, 01, Pencil, 08/05/04 I'd like to do a query like the following: SELECT Distinct CustID, CustName, ProductID, ProductName FROM CustomerTable C LEFT OUTER JOIN ***FIRST ROW ONLY OF*** ProductTable P ON C.CustID = P.CustID (Product Table would be ordered by DateOrdered DESC) The expected result would be a single result set with the following data: 01, Bill Knight, 02, Eraser 02, Bob Harrington, 03, Chalk 03, Doyle Brunson, 01, Pencil As you can see, the result set is a list of the distinct customers with the last product they purchased ONLY. I've played with syntax, but there doesn't seem to be any easy way to do this... Any ideas?