You are creating a query that lists employee information such as name, address, and dependent information. The query uses Personal Information as the driving table and joins the Dependents and Address tables. You notice many employees are missing from the result set.
What are the reasons?

Question

You are creating a query that lists employee information such as name, address, and dependent information. The query uses Personal Information as the driving table and joins the Dependents and Address tables. You notice many employees are missing from the result set.

What are the reasons?

Jack de Cort · Accepted Answer

Personal Information is joined to both the Dependents table and the Address table with an inner join.

Jack de Cort · Answer

Personal Information is joined to Dependents table with a left join and the Dependents table is joined to the Address table with a left join.

Jack de Cort · Answer

Personal Information is joined to Address table with a left join and the Address table is joined to the Dependents table with a left join.

Jack de Cort · Answer

Personal Information is joined to both the Dependents table and the Address table with a left join.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 41 - C_THR92_2405 discussion

Suggested answer: B

0 comments