Skip to Content
0
Jun 24, 2018 at 10:23 AM

Does the Multiprovider UNION work like a SQL FULL JOIN?

189 Views

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