Hi,
TableA:
ID, Value1
1, One
2, Two
TableB:
ID, Value2
1, Test1
3, Test3
4, Test4
In Left Join: TableA & TableB resultant table
JoinTable:
ID, Value1, Value2
1, One, Test1
2, Two, Null
In Left Keep: Both tables will be separate both are not joined physically just join logic is applied
TableA:
ID, Value1
1, One
2, Two
Left Keep(TableA)
TableB:
ID, Value2
1, Test1
Hope this helps you.
Regards,
Jagan.
.png "Luminary Alumni"){kind=icon}