[Solved] Combine each column from 2 different table into one table

by

[ad_1]

Select t2.account_number,t2.proposedaddress, t1.currentaddress
From table2 t2 left outer join table1 t1 on    
(t1.account_number=t2.account_number and   
Upper(Trim(t1.currentaddress)) like Upper(Trim(t2.proposedaddress)))

5

[ad_2]

solved Combine each column from 2 different table into one table