i'm learning sql and i came accross the subject of join.

i understand the concept behind joins. it's hard. you just want to join two or more tables.

from my understanding, left join and right join are pretty similar. they will return rows even if the left table has empty results or if it is the right table that has empty results.

Just a little thing to clarify for me: left/right based on what? on the horizontal axis? on the order of the tables in your db? on the order in which your tables appear in your query?

Now, more important. It seems that there a re many names for join. Inner Join, Natural Join, Join etc...

How many Join species are there? What's their specificites.

Sorry for these rather vague questions, but I hope you will be able to shed some lights.