This screenshot shows the option 'always include in the query' in the join editor.