Referring to the scenario above, what will happen to the final results when there is NO match between the tables?
The right table will return ALL rows
The right table will return NULL
Both tables will return NULL
The left table will return ALL rows
The left table will return NULL