Latham works in the logistics department for a large city bus system. As routes are changed,Latham accesses the internal database to ensure all records are accurate. The Bus Route System database includes a one-to-many relationship between the Bus Number and the Bus Routes with Bus ID as the common field. This allows the two tables to be joined to create a query based on data from both tables: Bus Number and Bus Routes.
-A join that relates records from the Bus Number table with the Bus Routes table based on the same Bus ID is an example of a(n)____ join.
A)inner
B)outer
C)self
D)common

Question

Latham works in the logistics department for a large city bus system.  As routes are changed,Latham accesses the internal database to ensure all records are accurate.  The Bus Route System database includes a one-to-many relationship between the Bus Number and the Bus Routes with Bus ID as the common field.  This allows the two tables to be joined to create a query based on data from both tables:  Bus Number and Bus Routes.
-A join that relates records from the Bus Number table with the Bus Routes table based on the same Bus ID is an example of a(n)____ join.
A)inner
B)outer
C)self
D)common

Quizplus · Accepted Answer

An inner join is used to combine records from two tables where there is a matching value in each table based on a common field. In this case, Latham is joining the Bus Number table with the Bus Routes table based on the common field Bus ID.

Latham Works in the Logistics Department for a Large City