ODBC error

[mr_zog]

I am trying to "limit" my results from a query to a MSSQL Db.

Here is the query:

$query1="SELECT top 10 * from RegistrationInfo where Account not in (SELECT top 10 * from RegistrationInfo order by Account) order by Account";

I receive the following error message:

Only one expression can be specified in the select list when the subquery is not introduced with EXISTS

Any help with the EXISTS statement would be great,

[lostcarpark]

In subqueries, you can generally only select one field (expression), in your select statement. This is so that SQL Server will know which field to evaluate against. For example:

"select * from table1 where field1 not in (select field2 from table2)"

This will select all rows in table1 where the value in field1 does not appear in field2 of table2.

The exception is when you use the "exists" comparison. For example:

"select from table1 where not exists (select from table2 where field2=table1.field1)"

In your case the error is easily fixed:

$query1="SELECT top 10 * from RegistrationInfo where Account not in (SELECT top 10 Account from RegistrationInfo order by Account) order by Account";

Hope this helps,

James

[mr_zog]

Thank you.

It is working. What made it more difficult is that the resulting array is pass to a graph.