Tag Administrative

list of emails for patients seen within the past 36 months.

Created by Stanley Hurwitz. select distinct CONCAT( “/” , ‘Demographic’, “/” ) As “Demographic”,demo.last_name”Last Name”,demo.first_name”First Name”,demo.phone “Home Phone”,demo.phone2″Alternate Phone”,demo.email”Email”,b.billing_date “Billing Date” from billing b, billingmaster bm, demographic demo where (demo.email != “” and b.billing_no = bm.billing_no and demo.demographic_no = b.demographic_no…