The result set will have three columns, column1, Two and Three — where Two contains values from table1.column2 and table2.column4 and Three contains values from table1.column3 and table2.column5.