leftJoin with multiple join parameters

ss1289

I want to run this query with Editor

SELECT ....
FROM table1
LEFT JOIN table2 ON table2.primarkeyid = table1.foriegnkeyid AND table2.statuscolumn = 1

I know I can add a ->where("table2.statuscolumn", "=", 1) but it excludes the table1 row all together if table2.statuscolumn != 1

allan

Hi,

Unfortunately at the moment there is no option to do multiple conditions for a single join statement in Editor. That is something that will be addressed in a future release.

Allan