You need to combine master data (right table) and transactional data (left table) using a referential join.
How will this referential join behave?
A . It is executed as an inner join when NO fields from the right table are requested.
B . It always returns all fields from the right table as a result data set.
C . It is executed as an inner join when a description mapping is defined between the left
table and the u right table.
D . It returns a result data set if the left table has a corresponding entry on the right table.
Answer: D