Distinctrow issues - want more detailed output

[asrg]

Hi .. I'm trying to do the following:
I have 2 tables, tblcustomer and tblorders.
I want the output to show the last order (tblorders.orderdate) date of the individual customers
===================================================
Select DistinctRow
tblcustomer.surname
From
tblcustomer Inner Join
tblorders On tblcustomer.CustID = tblorders.CustID
Order By
tblcustomer.surname
==================================================
I get an output thats just a list of customers that have an order, but doesnt show any details, the last order date..

I would like to show the date of the customers last order

Help

 

[PHV]

SELECT
tblcustomer.surname
, MAX(tblorders.orderdate) AS LastDate
FROM
tblcustomer LEFT JOIN
tblorders ON tblcustomer.CustID = tblorders.CustID
GROUP BY
tblcustomer.surname
ORDER BY
tblcustomer.surname

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[asrg]

Thanks so much, Im new, so these code snippets help me understand the use in real world.

Great , worked first time