Inner join, left join y right join en SqlServer y MySql

Inner join:

SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name;

Left join:

SELECT column_name(s) FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;

Right join:

SELECT column_name(s) FROM table1 RIGHT JOIN table2 ON table1.column_name = table2.column_name;

Referencia:

https://www.w3schools.com/sql/sql_join_inner.asp

https://www.w3schools.com/sql/sql_join_left.asp

https://www.w3schools.com/sql/sql_join_right.asp