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?