Hi,
Use Not null condition or Random Key word against Null values in both joining columns.
Attachments
Library
Quick Reference
Archives
Sample Index
2013 Indexes