Alternative to doing FULL OUTER JOIN for multiple tables? – Mysql
I needed to run the following on MySQL, but it doesn't allow FULL OUTER JOINs: SELECT COALESCE(t0.date, t1.date, t2.date, t3.date) AS date, COALESCE(t0.hits1, 0) AS hits0, COALESCE(t1.hits2, 0) AS hits1, COALESCE(t2.hits3, 0) AS hits2 COALESCE(t3.hits3, 0) AS hits3 FROM t0…