Programming, Data, Data Science, Machine Learning, Sql.
MySQL, UNION or UNION ALL might be the only viable alternatives, even if they could potentially impact performance. In summary, UNION and UNION ALL offer a workaround for the absence of FULL OUTER JOIN by combining results from LEFT JOIN and RIGHT JOIN. Use UNION to avoid duplicates and UNION ALL