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

by 


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

solved Combine each column from 2 different table into one table