Improving the Readability of Join Results

When you join tables, the system compares the data in the specified columns and displays the results of the comparison as a table of the qualifying rows. The results show a row for each successful join. Data from any of the tables is duplicated as needed.

Join query results replicate data from qualifying rows as needed in order to regularize the table display. As with any query, the results of a join query display as a table without altering the database tables in any way. The join operation simply permits the system to manipulate data from multiple tables as if it were contained in a single table.