Write SQL query to join two tables?

A JOIN condition is applied to join rows from two or added tables, founded on a similar column connecting them.

The various kinds of the JOINs in SQL:

• LEFT (OUTER) JOIN: Returns every record from the left chart, and the harmonized reports from the right record.
• (INNER) JOIN: Returns reports which have harmonizing values in both charts.
• RIGHT (OUTER) JOIN: Returns every record from the right record, and the harmonized reports from the left chart.
• FULL (OUTER) JOIN: Returns every record while there is in harmony with each left or right record.

The general query to join is as below for the list of the orders with all customer information in it.

SELECT OrderNumber, TotalAmount, FirstName, LastName, City, Country
  FROM Order JOIN Customer
    ON Order.CustomerId = Customer.Id