• +1-617-874-1011 (US)
  • +44-117-230-1145 (UK)
Live Chat
Follow Us:

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).

inner join example         inner join example


inner join

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

Inner join
Sql Inner Join Homework Help

Different type of SQL JOIN

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