Hack of Trades - All Opinions & Hacks My Own

How to Emulate a Full Outer Join?

Now, you may be interested and want to replicate the full outer join in MySQL, but since it doesn’t offer support for this type of join, you will need to develop a workaround yourself.Luckily, here is a straight forward approach to accomplishing this, using a combination of a left join, right join and union.SELECT A.VALUE_A, B.VALUE_BFROM ALEFT JOIN BON A.VALUE_A= B.VALUE_BUNIONSELECT A.VALUE_A, B.VALUE_BFROM ARIGHT.

Does it solve the problem at hand?

Your solution needs to solve the problem that was presented.

Is it sustainable?

So now that we have a solution in mind that solves the problem presented, the next area to focus on is sustainability.

Is it scalable?

If you’ve come up with a solution by now that passes the first two tests presented above, passing this third one will likely deem your solution the holy grail of solutions. The third test is scalability. Again, this is subject to the nature of the problem, but in most cases, you can’t go wrong designing your solution with scalability in mind.