Unless I'm misunderstanding what you want it sounds like you want to use a left join..

Something like..

select t1.concatenate, t2.concatenate

from table1 t1

left join table2 t2

on t1.concatenate = t2.concatenate

Maybe? You're trying to find nulls on a match so that's the first thing I think of.