I want to do a full outer join in MySQL. Is this possible? Is a full outer join supported by MySQL?
Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?