LabWindows/CVI

cancel
Showing results for 
Search instead for 
Did you mean: 

CVI - sql statement problem

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 !
0 Kudos
Message 1 of 2
(2,636 Views)
Hello,
You need to join two tables first. Then, you can refer to the firled of both tables, like:

SELECT TABLE1.FIELD1 ...

to avoid ambiguity when two or more fields from different tables use the same column name.

Mika Fukuchi
Application Engineer
National Instruments
0 Kudos
Message 2 of 2
(2,636 Views)