Dear all,

I would like to
(1) select patients who visit on specific date
(2) and to see where those patients have booked next appointment

I would like to do it via SQL query (like sqlexec(gnconn,"select ... ") like that:-

SELECT case_no, appt_time FROM appt_table a where a.case_no in (select b.case_no from pt_tx2 b where tx_date = '2006-10-06') 

But the query tooks 33 sec to complete?! what's wrong?

Also, this statement only to query for appointment that may be in the past, or far further, and it is not necessary to be next immediately appointment

Please help

Thanks in advance!