OK,

Thx everyone for replaying. I solved the problem the longg way, create separated queries and finally, a new query from the resulting tables of the 1st level queries.

I tried to do it with just one slect, but there where like 10 tables & 9 joins, and I think that VFP had a little truble handling it.

But the issue is solved, thank you very much