I understand that in the right join rows with values that don't correpond are dropped. such as follows:
SELECT * FROM (authors RIGHT JOIN books ON authors.author_id = books.author_id)
However, what if you were to join the tables with an inner join, but switched the tables. Such as:
SELECT * FROM (books INNER JOIN authors ON books.author_id = authors.author_id)
Wouldn't these joins have the same results? If so then why have a right join if you could just switch the tables around?