Final answer:
The process of linking records in different tables is typically known as joining tables in a database. This is accomplished through common fields that exist in both tables, allowing for powerful and flexible data retrieval.
Step-by-step explanation:
A joined table specifies an intermediate result table that is the result of either an inner join or an outer join. The table is derived by applying one of the join operators: CROSS, INNER, LEFT OUTER, RIGHT OUTER, or FULL OUTER to its operands. The process of linking records in different tables is indeed referred to as connecting the tables, but more commonly, it is known as joining tables in a database.
The advantage of a join includes that it executes faster. The retrieval time of the query using joins almost always will be faster than that of a sub query. By using joins, you can minimize the calculation burden on the database i.e., instead of multiple queries using one join query
This practice allows different sets of data to be related based on common fields, increasing the power and flexibility of database queries. For example, if you have a table for customers and another table for orders, you might connect the two tables using a customer ID that is present in both tables. This way, you can retrieve order details for a particular customer with ease.