SQL Join Homework Help

Urgenthomework brought you help in SQL Join:

The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns.

In SQL Joins Come In Two Flavors

• Those done with the SELECT clause.
• Those done with the JOIN clause.

JOIN is a query clause that can be used with the SELECT, UPDATE and DELETE data query statements to simultaneously affect rows from multiple tables. There are several distinct types of JOIN statements that return different data result sets.

The Basic JOIN Statement

A basic JOIN statement has the following format:

SELECT table1.table1columnID, table2columnID
FROM table1 JOIN table2
ON table1.table1columnID = table2.table1columnID;

Different type of SQL JOINs

The types of JOIN you can use and the differences between them,

• Inner Join
• Left Join
• Right Join
• Outer Join
• Left Join Excluding Inner Join
• Outer Excluding Join
• Right Join Excluding Inner Join
• Outer Join Excluding Inner Join