Hello,
I came across this diagram explaining how the Multiprovider UNION works.

From what I know, in SQL it's expected that the tables you are taking the UNION of must have the same number of columns and their data types must be compatible. This means that you are basically combining the records under the columns and not gluing the tables together side by side.Putting the tables together is an effect that follows a JOIN operation. To me, it looks like the diagram displays a SQL FULL JOIN on TABLE SALES and TABLE DELIVERY WHERE SALES PERSON = DELIVERY PERSON. Can someone confirm that or prove me wrong and show me how the Multiprovider UNION works like the SQL UNION?
Thanks