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
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