quote:

---

Originally posted by rohitkumar

select distinct c.enc_id,a.person_id, a.first_name + ' ' + a.last_name as fullname,
a.date_of_birth,b.rx_quanity, b.rx_refills,b.sig_desc,c.create_timestamp,
d.brand_name,d.generic_name,e.first_name + ' ' + e.last_name as provname,
e.other_lic_id,f.address_line_1,f.city,f.state,f.zip,f.phone,f.fax,h.diagnosis_code_id,
h.description,f.location_name
from person a
join patient_medication b on a.person_id = b.person_id
join patient_encounter c on b.enc_id = c.enc_id
join fdb_medication d on b.ndc_id = d.ndc_id
join provider_mstr e on b.provider_id = e.provider_id
join location_mstr f on b.location_id = f.location_id
left join patient_procedure g on c.enc_id = g.enc_id
left join diagnosis_code_mstr h on g.diagnosis_code_id_1 = h.diagnosis_code_id
where d.dose_form_desc IN
(
(select distinct dose_form_desc
from fdb_medication
where gcn = '94200')
) AND c.create_timestamp >= '7/15/08' and c.create_timestamp <= '7/16/08'
and f.location_name = 'CHC Soundview Clinic' and
a.first_name <> 'Lady' and a.first_name <> 'Test'
order by c.create_timestamp

---

quote:

---

Originally posted by rohitkumar

I cheated :) it was not me, I used a tool

---