Can You post the SQL itself to look in code?
There was a many changes between SQL behaviour from VFP6, 8 and 9 versions. You can see them in HELP
in VFP 9 Help under
SQL Language Improvementsin VFP 8 Help under
Behavior Changes Since Visual FoxPro 7.0
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.