Mysidia Adoptables Support Forum

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)
-   Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)
-   -   Outer Join in 1.3.4? (http://www.mysidiaadoptables.com/forum/showthread.php?t=5399)

ewe 03-24-2017 10:41 AM

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?

Hall of Famer 03-25-2017 07:04 PM

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 03-25-2017 11:03 PM

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.