Query join

[WilliamJ]

I have 2 tables that contain inventory information, one table has two fields
[Matl_Type] & [Location] (like 01 & 940) that together make up the items in
the other table [location] (like 01940). My problem is that I need to
concantenate [Matl_Type] & [Location] (01940) from the one table to correctly
join to the [Location] of the other table (01940). I can't figure out how to
concantenate in a join. These are Oracle tables that I have linked to.

 

[KARL DEWEY]

Concatenate in a query - [Matl_Type] & [Location] - and use that query to
join to the other table.

 

[WilliamJ]

Concatenate in a query - [Matl_Type] & [Location] - and use that query to
join to the other table.

Thanks Karl, I will try that.

 

[John Spencer]

In SQL view you should be able to use

SELECT ...
FROM TableA INNER JOIN TableB
ON TableA.Location = TableB.Matl_Type & TableB.Location

Is that now working? IF so, how is it not working? Are you getting no
results, wrong results, syntax errors?

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County