Click here to Skip to main content
15,915,603 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
"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
Posted
Updated 6-Jul-16 21:42pm
Comments
Maciej Los 28-Jun-16 16:52pm    
Not a question at all! You should - at least - provide a minimum information about your issue and post a question you want get answer!
Dave Kreskowiak 28-Jun-16 19:01pm    
Without seeing you actual SELECT statement and possibly the structure of the tables involved it's pretty much impossible to tell you anything useful.

1 solution

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
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900