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.
Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
