AIX 5L
DB2 8.2

Table A looks like this

Column1 Column2 Column3
123141 1 1
123142 1 2

Table B looks like this

Column1 ....
12314111
12314212


The primary key of Table B is all three columns in TableA. So I'm trying to figure an easy way to join these two tables using this information.

Thanks,

Charlie

SELECT ...
from tablea as a
inner join tableb as b on (b.column1 = a.column1||columns2||column3)
where ..

Andy

try this

SELECT ...
from tablea as a
inner join tableb as b on (b.column1 = column1||columns2||column3)
where ..

This *might* give incorrect results (viz. empty result table), depending on the datatypes of the columns; the above solution only works when a.column1 is either of datatype VARCHAR(n) or CHAR(6), and a.column2 is of datatype VARCHAR(n) or CHAR(1).
(Presuming that all data in your table is similar in width to what you example tells us ...)
Three alternative solutions (without the above restrictions):
(Now, the restriction being that b.column1 does not have embedded blanks...)
Finally, you may consider adding three (redundant) columns to table b, containing those substr()s; this might give a much more performant query (depending, of course, on the sizes of the two tables).

Thanks for the response. I got the concatenation query to work. However, I found this function is time costly to the overall query. I think I might add a column or table and perform the concatenation at INSERT instead.