In your Main.PRG along with other global SET commands, add the code..
SET ENGINEBEHAVIOR 70
to change the default behaviour of VFP8 in treating SQL syntax. The latest VFP8 SQL syntax are corrected to follow the SQL standard syntax at large and so differs in behaviour to the earlier versions. However to provide the earlier code compatibility, the above new SET ENGINEBEHAVIOUR 70 | 80 has been added in VFP8.
Still you can expect surprises in the syntax... "Using SET ENGINEBEHAVIOR set to 70 might lead to ambiguous results from SQL SELECT commands when the DISTINCT and UNION clauses are used with memos and the GROUP BY clause, the HAVING clause without a GROUP BY clause, and when using the LIKE clause."