According to Google search: since MySQL does not support full outer join, it could be simulated via union and/or union all. But both of these either remove genuine duplicates or show spurious duplicates.
What would be correct and efficient way?
This question seems relevant but couldn't get the answer of it.