Page 1 of 1

SalesForce ODBC driver - Right outer join

Posted: Wed 16 May 2018 07:24
by Meitalab
we have devart odbc driver for salesforce.
when I'm trying to write a simple select with right outer join, I get an error message that - "..unknown 'right' join type"
Is this join (right outer join) not supported in your odbc driver?

Thanks .

Re: SalesForce ODBC driver - Right outer join

Posted: Wed 16 May 2018 14:42
by MaximG
ODBC Driver for Salesforce is designed using SQLite engine, so to make queries using our drivers, you can use the syntax used in SQLite. However, this syntax does not support RIGHT OUTER JOIN