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