/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

0 vote268 views1 answer
Sqlalchemy get ids
SQL
1 vote222 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
-1 vote290 views2 answers
Installing mysql on centos 7
SQL
7 votes253 views2 answers
Get database size mysql
SQL
2 votes268 views4 answers
Sql query interview questions
SQL
0 vote239 views1 answer
Hallo
SQL
6 votes275 views2 answers
Mysql interval 1 day
SQL
22 votes286 views4 answers
Date format mysql
SQL
1 vote263 views1 answer
Multiple count in sql
SQL
1 vote270 views1 answer
Sysdate in sql
SQL