More specifically removal of main.EmailAddress != '' makes it return the user record.
- Shawn Plummer Systems Manager On Aug 30, 2012, at 9:37 PM, Shawn Plummer <[email protected]> wrote: > Adding this line makes it return no values. > > AND ( > main.EmailAddress != '' > AND main.EmailAddress IS NOT NULL > )
