I need to get a left outer join to join two tables and if table1 doesn not have a match in table too, to include all of table1 values and nulls for any additional values. I have this working on 5.0.18. However, my live host has 4.0.24 and my left outer joins return null values for the feild (id) matching up the two tables if table 2 did not have a match.
mysql.com wrote:
3.23, 4.0, 4.1 -
If there is no matching row for the right table in the ON or USING part in a LEFT JOIN, a row with all columns set to NULL is used for the right table.
I assume this is the problem. My question is how do I get the null to be replaced by the value in the left table like it does in version 5.0?
http://dev.mysql.com/doc/refman/4.1/en/join.html
