SQL: Use of UNION in subquery is invalid (Error 1813)

UNION is not supported in subqueries in Visual FoxPro. For more information, see SELECT - SQL.