Link to home
Start Free TrialLog in
Avatar of Patrick O'Dea
Patrick O'DeaFlag for Ireland

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?
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Patrick O'Dea

ASKER

Thanks Scott,

I try that later.
My difficulty was caused because I tend to write my queries using the wizard (rather than pure SQL).
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
THanks folks!