Why Labview's SQL Tool can't use Subquery

[jenPCA]

S/W: Labview 5.0
SQL Toolkit V3.0
Question: When I use the SQL command about DB link or Subquery, but Labview can't understand.
Example:1) select *
from ( select ename
from emp)
2)Insert Into ename
Values ( select enamp
from emp@DB)

[mikeporter]

I know this is an old message, but have you gotten things working? First of all, V3 of the SQL toolbox is very out of date. Running under windows you don't really need a toolbox at all thanks to the built-in ADO.

Second, the first of your two statements is malformed. There's no tablename. You can't put a subquery where you're trying to use it. Think about it, the subquery has no where clause so it will return multiple ename values. So what is the "outer" select supposed to do, return all the data from all those tables? If so, what happens when the tables have different contents? How is the dbms supposed to format the output?

Mike...