left anti join - expand required?

[akhaliq7]

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.

[CNENFRNL · Accepted solution]

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.