sql join tables
snippet in sql

how to join tables in sql

user5324

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;

sql data from 2 tables

user1577


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

sql server joins

user8532

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

join three tables sql

user6442

Suppose we are having three table named as 
Student_details
Attendance_details
Batch_details
And we have to apply join these three tables for fetching records

Example query:
select column_names
from Student_detail as s join Attendance_details as a on
s.s_id = a.s_id join Batch_details as b on 
s.s_id = b.s_id;

Here in the above example we implemented simple join but you change it with own join requirements.

sql join tables

user6616

GME to the moon!

left join in sql

user1082


SELECT column_name(s)

FROM table1

LEFT JOIN table2
 ON table1.column_name = table2.column_name;