This is probably a basic question, but I'm trying to build an SQL query for an access database that returns orders from a certain customer and I want to cross reference the customerID with the customer name from the customers table.
This is the query that I'm using
SELECT OrderTable.OrderNumber, OrderTable.CustomerID, OrderTable.OrderDate FROM [OrderTable] INNER JOIN [CustomerTable] ON CustomerTable.CustomerID = OrderTable.CustomerID WHERE OrderTable.CustomerID = 1
I don't get an error and it returns the correct records (all orders w/ customer ID = 1), however it does not return the customer name...it just returns the customerID for each order (always 1 as expected).
What am I doing incorrectly?