Forum Discussion
akhaliq7
Post Prodigy
Post Prodigyleft anti join - expand required?
I know in some cases you have to expand the columns when doing a left outer join/merge but when doing a left anti join/merge I don't think expanding is required. Is this the best practice to follow? As when I did a left anti join i delete the table column instead of expanding it and the number of rows returned were as I expected.
Of coz the deletion of the merged column does the trick since there is nothing but nulls in the merged column from a left anti-join.
1 Reply
CNENFRNLCommunity Champion
Of coz the deletion of the merged column does the trick since there is nothing but nulls in the merged column from a left anti-join.