======E-Mail Addresses For Active Patients	======

Back to [[QueryDirectory Query Directory]]

// 
I need a list of active patients with their email addresses. Only list those with emails, and sort in order by name.
//


%%(sql)
SELECT DISTINCT
a.lastname, a.firstname, b.email
FROM
patients a JOIN payors b ON a.payornum = b.payornum
WHERE
flag = 0 AND dischargedate IS NULL AND email > ''
ORDER BY 
a.lastname, a.firstname, b.email
%%


----
CategoryQueries