#1
|
|||
|
|||
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? Last edited by ewe; 03-24-2017 at 10:44 AM. |
#2
|
||||
|
||||
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.
__________________
Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site. |
#3
|
|||
|
|||
Welp I over-complicate things!
Writing a plain SQL statement without the prefix thing worked perfectly. Thank you so much! |
Tags |
join, mysql |
|
|
What's New? |
What's Hot? |
What's Popular? |