If equal sign ("=") is chosen at the "Select Table" window, then the relation for tables is "Inner Join".
Two table is linked by their "key". The result is a new table that contains data comes from the two tables.
All participated tables are equally executed. The execution sequence is:
1. All data columns for the two participant data tables composes a temporary data table;
2. Filter all qualified data out.
For Example:
Assume there are two data tables: supplier and product
supplier
| supplierID | supplierName | productID | price |
| s01 | abc | 1000 | $200 |
| s02 | xyz | 1001 | $100 |
product
| productID | productName | qty |
| 1000 | Table | 50 |
| 1001 | Chair | 100 |
Inner Join Condition: supplier.productID = product.productID
Join Result:
| supplierID | supplierName | productID | productName | qty | price |
| s01 | abc | 1000 | Table | 50 | $200 |
| s02 | xyz | 1001 | Chair | 100 | $100 |
Note:
1. When the table contains redundant records, the joined table will look like following:
For Example:
supplier
| supplierID | supplierName | productID | price |
| s01 | abc | 1000 | $200 |
| s02 | opq | 1001 | $100 |
| s03 | xyz | 1000 | $220 |
product
| productID | productName | qty |
| 1000 | table | 50 |
| 1001 | chair | 100 |
Join Condition: supplier.productID = product.productID; the result is:
| supplierID | supplierName | productID | productName | qty | price |
| s01 | abc | 1000 | table | 50 | $200 |
| s02 | opq | 1001 | chair | 100 | $100 |
| s03 | xyz | 1000 | table | 50 | $220 |
2. Excel server system will automatically link the data tables for the same report template.