Using the Join Node

The Join node combines data from multiple sources based on shared values. A column represents a category of information, such as an opportunity source or account name.

Inner join	Returns matching field values from the two selected columns.
Left join	Returns matching field values from the left column and the matched records from the right column.
Right join	Returns matching field values from the right column and the matched fields from the left column.
Full join	Returns matching field values when there’s a match in either the left or right column.