Revision [238]
Last edited on 2009-06-29 12:05:38 by SethKriegerAdditions:
======E-Mail Addresses For Active Patients ======
I need a list of active patients with their email addresses. Only list those with emails, and sort in order by name.
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
I need a list of active patients with their email addresses. Only list those with emails, and sort in order by name.
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
Deletions:
comments here appear in italics
paste your tested query here