Hello. I apologize that my original post was a bit unclear. Based on the table in my original post, I am able to pull the following

2689222701Extra18106

2689322701Extra28106

with this script..

select Column1, Column2, Column3, Column4

from Table

where Column2 in

(select Column1 from Table

where Column1 = '22701')

However, I would like to come up with a script that will display the following results..

2689222701Extra18106

2689322701Extra28106

2689426892ExtraSub18106

Does this make more sense?

Thanks you!