如何创建复杂连接 [英] How do I create a complex join

问题描述

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'我收到以下错误：只允许列，指定谓词和运算符。



我尝试过：



我尝试使用表达式构建器函数创建复杂连接

解决方案

Quote：

Enterprise Warehouse..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

解决方案

Quote:

"Enterprise Warehouse".."SYSADM"."D_EXTERNAL_HIGHSCHOOL_SNP"."EXT_ORG_LD" <> 'Not/Applicable'

This does not belong to the Join conditions, move it to the WHERE statement

这篇关于如何创建复杂连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！