• + 1 comment

    Unfortunately there is no outer join in MySQL - you have to use some nonsense involving a union of a left join and a right join.