/SQL/Sqlstate[imssp]: the active result for the query contains no fields.

Sqlstate[imssp]: the active result for the query contains no fields.

with (SELECT afield INTO #temptable FROM atable 
WHERE anotherfield = 'somevalue') AS temptable;

SELECT afield,anotherfield,onemorefield FROM atable 
where afield NOT IN (SELECT * FROM temptable);

Similar codes

2 votes204 views2 answers
Sqlite_busy: database is locked
SQL
0 vote214 views1 answer
Codigo crear tablas sql server
SQL
0 vote222 views1 answer
Mysql where in maintain order
SQL
0 vote187 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote185 views1 answer
Lesser than or equal to symbol in postgres
SQL
3 votes209 views1 answer
Oracle list invalid password logon denied
SQL
1 vote198 views1 answer
Altrer name column postgres
SQL
6 votes221 views2 answers
Mysqldump password in file
SQL
-1 vote276 views1 answer
Minus vs except in sql
SQL
2 votes311 views1 answer
Sql ends with string
SQL