/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

7 votes307 views4 answers
What is my mysql version
SQL
0 vote263 views1 answer
Postgres create database if not exists
SQL
2 votes314 views3 answers
Row number mssql
SQL
9 votes328 views3 answers
Find all tables with column name
SQL
10 votes288 views4 answers
Join with multiple conditions sql
SQL
0 vote320 views2 answers
List all constraints in postgres
SQL
1 vote284 views1 answer
Show indices in mysql table
SQL
0 vote296 views1 answer
Mysql count grouped rows
SQL
0 vote331 views1 answer
Get last inserted primary key
SQL
0 vote284 views2 answers
Database owner can't create new tables postgres
SQL