I am making a query using sqlQuery in Silverstripe 3.1 . Now when i try to add an inner join using
$sqlQuery->addInnerJoin('Member', 'testTable.OwnerID = Member.ID');
the raw query i am getting with this is something like
INNER JOIN "Member" ON testTable.OwnerID = Member.ID,
which when executed in mysql gives syntax error,as there should be no double quotes in the table name,when i remove the quotes,it works.
But how can i resolve this in my code?
The generated SQL is correct. SilverStripe runs MySQL in ANSI mode, which means that database, table and column names should be enclosed in double quotes (“) rather than the normal back ticks (`). If you are running the query in a mysql shell, or through something like PHPMyAdmin, you need to run