>>BTW, the following SELECT statement is illegal unless customer_id is the only field in the table.

>>select c.*, count(*) as cnt from customer c group by customer_id having cnt > 2

Only in VFP 8.0 Right? I've used this in VFP 7.0 just fine.