SalesForce ODBC driver - Right outer join

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
Meitalab
Posts: 1
Joined: Wed 16 May 2018 06:50

SalesForce ODBC driver - Right outer join

Post by Meitalab » Wed 16 May 2018 07:24

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 .

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: SalesForce ODBC driver - Right outer join

Post by MaximG » Wed 16 May 2018 14:42

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

Post Reply