join types

JOINING 2 Tables in sql

SELECT X.Column_Name , Y.Column_Name2
FROM TABLES1_NAME X 
INNER JOIN TABLES2_NAME Y ON X.Primary_key = Y.Foreign_key;


--FOR EXAMPLE
--GET THE FIRST_NAME AND JOB_TITLE
--USE EMPLOYEES AND JOBS TABLE
--THE RELATIONSHIP IS JOB_ID

SELECT E.FIRST_NAME , J.JOB_TITLE
FROM EMPLOYEES E
INNER JOIN JOBS J ON J.JOB_ID = E.JOB_ID;

SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate
FROM Orders
INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID;

INNER JOIN is used when retrieving data from multiple tables and
will return only matching data.

LEFT OUTER JOIN is used when retrieving data from multiple tables and
will return left table and any matching right table records.

RIGHT OUTER JOIN is used when retrieving data from multiple tables
and will return right table and any matching left table records

FULL OUTER JOIN is used when retrieving data from multiple tables
and will return both table records, matching and non-matching.