Latham Works in the Logistics Department for a Large City

Multiple Choice

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