You want to use a referential join for a combination of transactional data (left table) and master data (right table).
How will this referential join be processed? Note: there are 2 correct answers to this question.
It is executed only when columns from both tables are requested
It shows all transactional data with an existing master data record
It shows all master data to assure the referential integrity
It is an inner join that assumes that referential integrity is given
Submit