It doesn't take a SQL expert to join tables using Sage Intelligence. The Graphical Join Tool in the Connector makes it fairly simple.
Oftentimes the data that we need for our reports comes from joining two or more different tables. The following process allows you to quickly join tables without having to know SQL, by just clicking and dragging a connection between the fields within a group of tables.
Before you use the Graphical Join Tool, it is best to have all your data requirements and know the tables and fields you are going to use. Here is the process:
It is recommend that you test your container after you have created your new join. You can do this by right-clicking on the container and choosing Check/Test from the context menu. If your graphical join is correct, you will receive an alert stating that your check succeeded. If not, you need to check your join, container and connection for any errors. You are now able to add expressions to your container.
If you need to add more tables to your join you can do this by selecting the Graphical Join Tool button again, and then selecting the Add Table button and repeating the process described above.