That usually happens to me in one of the following:
1.- There are duplcate names of fields in the query, when they come from different tables, and not using a LOAD statement.
2.- The ODBC / OLEDB driver doesn't understand a comma or some other character in the FROM clause.
I have worked that around renaming fields with a LOAD stantement or using an INNER JOIN clause instead of a FROM / WHERE table.field = table2.field2.
Hope that helps!
There's no ";" after the from line.
Both tables have fields with same names (but different data!) and linked fields are designed with different names (table1.id is linked with table2.name but there's also a table2.id field).
Miguel (or anybody), could you give me an example in order to solve it? (I'm a database newbie....).
Thank you very much for alll the answers.