[Care2002-developers] search for a patient

Sat, 03 Jul 2004 14:03:08 -0700

Hallo,

 

if you search for a patient you always get the employees too. I would like to change the sql into the following one:

 

SELECT a.pid, name_last, name_first, date_birth, addr_zip, sex, death_date, a.status, encounter_nr, b.pid FROM care_person a, care_encounter b WHERE  a.pid=b.pid

 

Anyone has a better ides?

 

Regards

Joachim

Reply via email to