Performs a nested join between table1 and table2 from specific columns and produces the join result as a newColumnName column for each row of table1.
