Yossi,
it is always better to tell us what version of VFP you use, especially when the question is SELECT-SQL related, because with VFP9 you could do more than previous versions of VFP.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.