I have a table with all my Customer Orders and I'm trying to return a single record for the Earliest OrderPlaced but I cannot for the life of me return the single oldest Order Number according to the CustomerID.
I have 2 tables:
CustomerOrders Customers
OrderNumber (pk) CustomerID (pk)...