However, if I do this as follows:
SELECT a.case_no,min(appt_time) FROM appt_table a inner JOIN (select case_no FROM pt_tx2 where tx_date='2006-10-06') b ON a.case_no = b.case_no group by 1 order by 1
Best regards,
Aaron Chu
********************************************************
Working with Visual FoxPro is a lot of FUN!
********************************************************