You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
--We had a request for the same sort of report as the one on patrons with email as notification method but no email address on file, but rewritten for phones. Here's the query (this works in the client's SQL search):
SELECT DISTINCT p.patronID
FROM PatronRegistration pr (NOLOCK)
JOIN Patrons p (NOLOCK) ON p.PatronID = pr.PatronID