Hi Sergey,

Thanks for the suggestion. I got the format for the SELECT from the Help File examples page. Here is an example from Help:

SELECT a.company, b.idate, b.itotal ;
FROM customer a, invoices b ;
WHERE a.cno = b.cno

Thanks,

TFISHER

>Terry,
>
>The letters a-j are reserved words in foxpro and reference the work areas from 1 to 10. It confuses foxpro totally. I recomend to use table names not aliases in select.