When you use Keep the join is perform as normal join weather it is Left, Right, outer, Inner joins but the second table is available to use in the data model. Actually the data is reduced in the table example if you use Left join then the data in the keep table is only of left tables id records.
