本文介绍了具有WHERE子句的DB2 SELECT EXCEPT的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试使用SPUFI提交SQL查询来比较z/OS中DB2数据库中的两个表.
I'm trying to compare two tables in a DB2 database in z/OS using SPUFI to submit SQL queries.
我正在通过使用EXCEPT来查看两个SELECT查询之间的区别.
I'm doing this by using EXCEPT to see the difference between two SELECT queries.
我需要使用WHERE子句从第一个查询中过滤SELECT语句.
I need to filter the SELECT statement from the first query with a WHERE clause.
SELECT KEY_FIELD_1,LOOKUP_FIELD_1 FROM TABLE_1 WHERE FILTER_FIELD = '1' EXCEPT SELECT KEY FIELD_2,LOOKUP_FIELD_2 FROM TABLE_2我得到了结果,但它也返回了错误-199这是因为第二个SELECT语句中没有WHERE子句吗?
I got results back, but it also returned an error -199 Is this because the WHERE clause is not present in the second SELECT statement?
ERROR: ILLEGAL USE OF KEYWORD EXCEPT. TOKEN <ERR_STMT> <WNG_STMT> GET SQL SAVEPOINT HOLD FREE ASSOCIATE WAS EXPECTED推荐答案
尝试引入括号,例如
( SELECT KEY_FIELD_1,LOOKUP_FIELD_1 FROM TABLE_1 WHERE FILTER_FIELD = '1' ) EXCEPT ( SELECT KEY FIELD_2,LOOKUP_FIELD_2 FROM TABLE_2 )更多推荐
具有WHERE子句的DB2 SELECT EXCEPT
发布评论