Hello,
I use Labwindows/CVI odbc (*.dbf) with SQL toolkit 1.1 to record results from tests bench, one table per month (2003-01.dbf, 2003-02.dbf,...)
I want to get results from several tables.
The SQL statement (for example) 'Select FIELD1 FROM TABLE1, TABLE2' returns an error: 'More than one field as this name : FIELD1.
How can I do to succeed in ?
The SQL operator 'UNION' does not enable to sort (or anything else) the rows from the returned recordset --> 😞
Help me, please !