SQL statement needed

[chrisjk]

I'm suffering from real brain fade at the moment and I just can't figure this out.

We have 2 tables, customers and orders (one2many). What sql statement/s can I use to obtain the last order date for each customer

It seems so simple but I'm going mad

Thanks

[seoptimizer2001]

Select DISTINCT(CustomerName), max(b.OrderDate) from Customer a
Inner Join Orders b on b.CustomerID = a.CustomerID
Group By a.CustomerName
Order By a.CustomerName

I think that should do it!

[chrisjk]

Thanks a lot man, you are a lifesaver!!

[seoptimizer2001]

Not a prob, I think we all have those days!