Description |
SQL for Open Call Entires has an Inner Join on user, but the converted records to not have a valid i21 User, so this should be set to a Left Join instead since there is no guarantee that Origin converted data will have a valid user.
Old - INNER JOIN tblSMUserSecurity L ON G.intUserID = L.intUserSecurityID
Proposed - LEFT JOIN tblSMUserSecurity L ON G.intUserID = L.intUserSecurityID
|