The screenshot shows an example of join settings Always include in query and Preserve Grain displayed in a table node.