what are different types of joins in sql code example

Example 1: sql server joins

SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate
FROM Orders
INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID;

Example 2: sql join

SELECT Coloumn_Name(s) FROM Table_1, Table_2 WHERE Table_1.Primary_key = Table_2.Foreign_key;