Re: Rewrite Full Outer Join into Subquery

[Rick James]

Are you mistakenly tying the date_purchased to the budget_date? Or do you need two instances of dim_date?

I dislike using normalizing out dates and other "continuous" values.

You gave part of a RIGHT JOIN..UNION..LEFT JOIN, but it would be nice to see the FROM part, too. While debugging it, get rid of all the fluff.

RIGHT..UNION DISTINCT..LEFT is the way to get all the rows in one table or another or both. Is that what you want? Some competing products have syntax for such ("*=*"), MySQL does not.

Please provide SHOW CREATE TABLE, too.