A very interesting article, but I have a question. Surely if you have a trusted foreign key constraint in place between two tables, you should not write such an "if...

Good question, highlighting that union doesn't simply remove a duplicated row where the duplicate exists on both sides of the union, but will also remove a duplicated row where the...