thanks for reply, problem fixed,
On Mon, Jan 18, 2010 at 6:06 AM, Dan Nelson wrote:
> In the last episode (Jan 17), bharani kumar said:
> > SELECT updateDate,cHospital,cHospital1,cHospital2 FROM med_patient WHERE
> > cCurstatus!='completed' AND cMmrcashworker = '2' AND
> > (cHospital = '1234'
In the last episode (Jan 17), bharani kumar said:
> SELECT updateDate,cHospital,cHospital1,cHospital2 FROM med_patient WHERE
> cCurstatus!='completed' AND cMmrcashworker = '2' AND
> (cHospital = '1234' OR cHospital1 = '1234' OR cHospital2 ='1234') AND
> updateDate between '2010-01-01' and '2010-01-
SELECT updateDate,cHospital,cHospital1,cHospital2 FROM med_patient WHERE
cCurstatus!='completed' AND cMmrcashworker = '2' AND
(cHospital = '1234' OR cHospital1 = '1234' OR cHospital2 ='1234') AND
updateDate between '2010-01-01' and '2010-01-28' order by id desc
I have one patient entry,and his up
