Help on query - customers and *last order only*?

RSIboy

Registered User.
Local time
Today, 01:42
Joined
Jul 1, 2004
Messages
32
Hi

I have a database with Customers and Orders and want to write a query that will list each customer and only their last order.

For simplicity, say I have tblCustomer (CustomerID, Customer Name) and tblOrder(OrderID, Customer ID, OrderDate, OrderDescription)

I want the query to return *every* customer, even if they have never placed an order.

Any help will be much appreciated...

Thanks
 

Users who are viewing this thread

Back
Top Bottom