Has anyone used RIGHT JOIN in the real world?

Question

I was wondering how frequently RIGHT JOINs are used. Does anyone have any practical experience? I almost exclusively use LEFT JOINs. Thanks for any input!

Answer 1

Left join and right join are the same.

SELECT * FROM a LEFT JOIN b

is the same as

SELECT * FROM b RIGHT JOIN a

It's sometimes more convenient to use one over the other, but using only left joins works too.

Answer 2

not yet 😂