Left joins can increase the number of rows in the left table if there are multiple matches in the right table.
I know we can use the data step to select only the first or last match a join finds, but this parameter should be something the user can select inside of EG's Query Builder/Join Tables function, instead of having to dip down into code.
I can't seem to find a way to replicate this in the drag and drop of EG. Have to use code directly. If I use EG Query Builder and a left join on NameID, Bob shows up twice in the Final table as his NameID matches two orders. The code below only selects the first order found because of the first.nameid statement; strike it and Bob shows up twice. Ideally, you'd be able to handle multiple matches on the join inside of the EG Join Tables layout directly.