SubSonic 2.2 Left join error

Question

I know this may have been answered but SubSonic 2.2 causes an error in the SQL provider when trying to do a Left join (Left inner join to subsonic)

instead of creating SQl like

SELECT * FROM table1
LEFT JOIN table 2 ON table1.id = table2.id

it creates:

SELECT * FROM table1
LEFT INNER JOIN table 2 ON table1.id = table2.id

and this errors as invalid SQL code.

is there a work around? As i spose you're not supporting it at all anymore?

Answer 1

Don't really know MSSQL Syntax, but with MySQL there are no "LEFT INNER" or "LEFT OUTER" joins. However if you change your code to a left outer join, that works (with MySQL)

Answer 2

Can i bump this as no one replied with the answer

Answer 3

After contacting the subsonic mailing list it would appear i simply needed to change the order that my fields where in the inner join, after doing this it should work.