Sep 18, 1996 · SQL JOIN. A JOIN clause is used to combine rows from two or more tables, based on a related column between them. Let's look at a selection from the "Orders" table:

INNER is the default join type for JOIN, so when you write JOIN the parser actually writes INNER JOIN.

Sep 18, 1996 · Supported Types of Joins in MySQL. INNER JOIN: Returns records that have matching values in both tables; LEFT JOIN: Returns all records from the left table, and the matched records from the right table; RIGHT JOIN: Returns all records from the right table, and the matched records from the left table; CROSS JOIN: Returns all records from both tables

The LEFT JOIN command returns all rows from the left table, and the matching rows from the right table. The result is NULL from the right side, if there is no match. The following SQL will select all customers, and any orders they might have:

Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems. Start learning SQL now » Examples in Each Chapter

JOIN. A JOIN clause is used to combine rows from two or more tables, based on a related column between them. Let's look at a selection from the products table:

SQL Server has many built-in functions. This reference contains string, numeric, date, conversion, and some advanced functions in SQL Server.

The SQL WHERE Clause. The WHERE clause is used to filter records. It is used to extract only those records that fulfill a specified condition.

Example. Join OrderDetails with Products, and use SUM() to find the total amount:

INNER JOIN: SELECT column_name(s) FROM table_name1 INNER JOIN table_name2 ON table_name1.column_name=table_name2.column_name: LEFT JOIN: SELECT column_name(s) FROM table_name1 LEFT JOIN table_name2 ON table_name1.column_name=table_name2.column_name: RIGHT JOIN: SELECT column_name(s) FROM table_name1 RIGHT JOIN table_name2