Sql INNER JOIN Homework Help

This is the simplest, most understood Join and is the most common. This query will return all of the records in the left table (tableX) that have a matching record in the right table (tableY).

SELECT "select_list"
FROM TableX X
INNER JOIN TableY Y
ON X.Key = Y.Key

EXAMPLE OF INNER EXCLUDING JOIN :

SELECT X.PK, X.Value,
Y.Value, Y.PK
FROM TableX X
INNER JOIN TableY Y
ON X.PK = Y.PK

Different type of SQL JOIN

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 Joine