Question

The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ______________

(a) CARTESIAN JOIN

(b) CROSS JOIN

(c) INNER JOIN

(d) RIGHT JOIN

I had been asked this question in examination.

My doubt is from Functions in portion Data Type Reference, Operators and Functions of MySQL

Answer 1

Right option is (d) RIGHT JOIN

For explanation I would say: In a ‘RIGHT JOIN’, the output is produced for every row of the right table, even if it does not exist in the other table. This is the reason why it is called a ‘RIGHT JOIN’. ‘RIGHT JOIN’ and ‘LEFT JOIN’ are a kind of OUTER JOIN.