Outer Join in 1.3.4?
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? |
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.
|
Welp I over-complicate things! :ooo:
Writing a plain SQL statement without the prefix thing worked perfectly. Thank you so much! :happyc: |
All times are GMT -5. The time now is 03:50 AM. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.