[Microsoft][ODBC Visual FoxPro Driver]Syntax error (#200)

[jclark33]

FoxPro_UnionQuery Problems

I'm having trouble with a union query that calls 2 linked foxpro tables, I can run both queries seperatly but when i add the union to the second select statement, i get the error [Microsoft][ODBC Visual FoxPro Driver] Syntax error(#200)... any ideas ?

 

[WayneRyan]

j,

This link should help:

http://support.microsoft.com/default.aspx?scid=/servicedesks/bin/kbsearch.asp?Article=231714

If it doesn't (you say the queries work individually), then check your
queries. In a Union query, BOTH queries must have the same number
of columns AND the same datatypes.

Wayne