/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

3 votes270 views2 answers
Mysql import gz
SQL
0 vote289 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote296 views2 answers
Suse Linux restart MySQL
SQL
0 vote232 views1 answer
Mysql percentage of total
SQL
11 votes264 views1 answer
Sql query to find duplicates in column
SQL
0 vote280 views2 answers
Sql auto update dupdated_at
SQL
0 vote260 views1 answer
Monthly Birthday SQL Query
SQL
2 votes274 views1 answer
Where clause for child record apex
SQL
0 vote251 views1 answer
Sqlite closes value
SQL
4 votes315 views4 answers
Check constraint in ms sql
SQL