Join Two Tables

I have one table with columns A, B, and C and another table with columns D, E,  and F. How do I make one table with columns A, B, C, D, E, and F? 


Thanks so much!

Thanks for any suggestions

Well you can simply use the joiner node for this.

The question is how do you want them joined? By a common identifier in column A and column D?
If so, in joiner node choose column a for left hand join, and column D as right join.

If its simply a side by side join with no common identifier, you need to set the rowids to be the same. Use the rowid node on both tables first, then use the joiner node and choose to join by rowid for the left table and the right table.

Hope this helps.


Thanks so much! Exactly what I was looking for.