Patrick O'Dea
asked on
DO I need a second Query to do this?
Hi,
I have a simple CUSTOMER table.
[CustomerID], [CustomerName], [Location]
Location is in the format 99999.
The 3rd digit of the location field is used to JOIN to another table called "LocationDescription".
Question : How can I join the two table together (without using a separate query). Is it possible?
I have a simple CUSTOMER table.
[CustomerID], [CustomerName], [Location]
Location is in the format 99999.
The 3rd digit of the location field is used to JOIN to another table called "LocationDescription".
Question : How can I join the two table together (without using a separate query). Is it possible?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THanks folks!
ASKER
I try that later.
My difficulty was caused because I tend to write my queries using the wizard (rather than pure SQL).