mysql join two tables

SELECT *
FROM Orders
LEFT JOIN Customers
=;

Joins are used with select statement. it is used to select data from multiple table.
Types:
MySQL INNER JOIN (or simple join)
MySQL LEFT OUTER JOIN (or LEFT JOIN)
MySQL RIGHT OUTER JOIN (or RIGHT JOIN)

Inner JOIN :
The INNER JOIN is used to return all rows from multiple tables where the join condition is satisfied. It is the most common type of join.

Left Outer Join:
The LEFT OUTER JOIN returns all rows from the left hand table specified in the ON condition and only those rows from the other table where the join condition is fulfilled.

Right Outer Join:
The Right Outer Join returns all rows from the RIGHT-hand table specified in the ON condition and only those rows from the other table where he join condition is fulfilled.

Different types of the JOINs in SQL:

(INNER) JOIN: Returns records that have matching values in both tables
LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table
RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table
FULL (OUTER) JOIN: Returns all records when there is a match in either left or right table

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

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

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

# Full
SELECT column_name(s)
FROM table1
FULL OUTER JOIN table2
ON table1.column_name = table2.column_name
WHERE condition;

SELECT user_id, user_name
FROM users
UNION
SELECT organization_id, organization_name
FROM organizations