Joins in Information Designer
I am trying to create a join between two data tables in information designer. I currently am using a left join. The problem is it leaves out information from the first table. What I need is for the matching rows between table 1 and table 2 to be joined, and also include extra rows from each table. Using Right or Left Join always excludes the extra rows from one of the tables. I tried free hand %1 (+) = %2 (+) but that didn't work.