Examine the relational tables depicted below. A user needs a query that includes InventoryStockID, and Description from the inventory table and the corresponding SaleIDs and Quantities Sold from the Stockflow1 table. Inventory items that have not yet been sold need to be included in the query result, with blanks showing for the corresponding Sale IDs and Quantities Sold. What kind of join is required to generate the desired result? Assume the Inventory table is the first table listed in the query statement (and is thus considered the "left" table) and the Stockflow table is the second table listed in the query statement (and is thus considered the "right"
Table).

A) A left inner join is required
B) A right inner join is required
C) A right outer join is required
D) No join is required
E) A left outer join is required

Question

Examine the relational tables depicted below. A user needs a query that includes InventoryStockID, and Description from the inventory table and the corresponding SaleIDs and Quantities Sold from the Stockflow1 table. Inventory items that have not yet been sold need to be included in the query result, with blanks showing for the corresponding Sale IDs and Quantities Sold. What kind of join is required to generate the desired result? Assume the Inventory table is the first table listed in the query statement (and is thus considered the "left" table) and the Stockflow table is the second table listed in the query statement (and is thus considered the "right"
Table). 
 
A) A left inner join is required 
B) A right inner join is required 
C) A right outer join is required 
D) No join is required 
E) A left outer join is required

Quizplus · Accepted Answer

The Answer of Examine the relational tables depicted below. A user needs a query that includes InventoryStockID, and Description from the inventory table and the corresponding SaleIDs and Quantities Sold from the Stockflow1 table. Inventory items that have not yet been sold need to be included in the query result, with blanks showing for the corresponding Sale IDs and Quantities Sold. What kind of join is required to generate the desired result? Assume the Inventory table is the first table listed in the query statement (and is thus considered the "left" table) and the Stockflow table is the second table listed in the query statement (and is thus considered the "right"
Table). 
 
A) A left inner join is required 
B) A right inner join is required 
C) A right outer join is required 
D) No join is required 
E) A left outer join is required

Examine the Relational Tables Depicted Below