Join Statements Screen (Magic xpi 3.x)

The Join Statements screen displays a record for each connection that exists between all of the tables selected for this object. The JOIN statement lets you indicate the relationship between the data in each table by defining how to match data from one table with the data from the other.

For example, if you select tables called Order, OrderLine, and Product, two records are created. The first record specifies the relationship between A and B and the second specifies the relationship between B and C, therefore the Joins will be Order.OrderNumber = OrderLine.OrderNumber, and OrderLine.ProductCode = Product.ProductCode.

Once you select a column from a table on one side, you cannot select the columns of the same table on the other side. In other words, each side can only have columns from the same table, and it is up to you to decide which side will belong to which table.

Make sure that for each Table Join record, there is at least one record of joined columns. This will be validated before you can continue.

After you select the Join information, click Next to display the Where Clause and Order By Definition Screen.