Outer Join in 1.3.4?

[ewe]

I see that _select_query in the Database class does an inner join and some queries listed here on the forums have left joins but they also call a function which I did not see in the 1.3.4 functions.

I need to keep the null values in the column that is the join condition. So what's the best way to accomplish a left outer join?

[Hall of Famer]

Well if you want a custom query, since call $mysidia->db->query($query) and write the query string in $query. Mysidia's Database class extends from PDO, so this should be pretty easy to achieve.

[ewe]

Welp I over-complicate things! :ooo:
Writing a plain SQL statement without the prefix thing worked perfectly.

Thank you so much! :happyc: