具有WHERE子句的DB2 SELECT EXCEPT [英] DB2 SELECT EXCEPT with WHERE clause
本文介绍了具有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的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文