问题描述
Enterprise Warehouse。。SYSADM。D_EXTERNAL_HIGHSCHOOL_SNP。EXT_ORG_SNP_SID=企业仓库。。SYSADM。F_ADM_WKLY_SNP。HS_EXT_ORG_SID和企业仓库.. SYSADM。D_EXTERNAL_HIGHSCHOOL_SNP。EXT_ORG_LD<> 'Not / Applicable'我收到以下错误:只允许列,指定谓词和运算符。
我尝试过:
我尝试使用表达式构建器函数创建复杂连接
这不属于 Join
条件,将其移至 WHERE
语句
"Enterprise Warehouse".""."SYSADM"."D_EXTERNAL_HIGHSCHOOL_SNP"."EXT_ORG_SNP_SID" = "Enterprise Warehouse".""."SYSADM"."F_ADM_WKLY_SNP"."HS_EXT_ORG_SID" AND "Enterprise Warehouse".."SYSADM"."D_EXTERNAL_HIGHSCHOOL_SNP"."EXT_ORG_LD" <> 'Not/Applicable' I get the following error: only columns, designated predicates and operators are allowed.
What I have tried:
I tried creating a complex join with the expression builder function
This does not belong to the Join
conditions, move it to the WHERE
statement
这篇关于如何创建复杂连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!