Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to join tables in sql

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;

Comment

joins in sql

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.



INNER JOIN :
SELECT select_list From TableA A
Inner Join TableB B
On A.Key = B.Key


LEFT OUTER JOIN :
SELECT select_list From TableA A
Left Join TableB B
On A.Key = B.Key

(where b.key is null)//For delete matching data



RIGTH OUTER JOIN :
SELECT select_list From TableA A
Right Join TableB B
On A.Key = B.Key


FULL JOIN :
SELECT select_list From TableA A
FULL OUTER Join TableB B
On A.Key = B.Key

Comment

Syntax for JOIN in SQL

SELECT table1.column1,table1.column2,table2.column1,....
FROM table1 
INNER JOIN table2
ON table1.matching_column = table2.matching_column;


table1: First table.
table2: Second table
matching_column: Column common to both the tables.
Comment

joining tables in sql

SELECT orders.order_Number, customers.First_Name, customers.Last_Name, customers.Address
FROM orders
INNER JOIN Customers ON orders.customers_id=customers.id;
Comment

join sql

#INNER JOIN: Intersection between 2 tables
SELECT *
FROM A
INNER JOIN B ON A.key = B.key

#LEFT JOIN: left table with the intersection joined to the right table
SELECT *
FROM A
LEFT JOIN B ON A.key = B.key

#LEFT JOIN(without intesection): left table without the intersection joined
#								to the right table
SELECT *
FROM A
LEFT JOIN B ON A.key = B.key
WHERE B.key IS NULL

#RIGHT JOIN: right table with the intersection joined to the left table
SELECT *
FROM A
RIGHT JOIN B ON A.key = B.key

#RIGHT JOIN(without intesection): right table without the intersection joined
#								to the left table
SELECT *
FROM A
RIGHT JOIN B ON A.key = B.key
WHERE A.key IS NULL # there seems to be a mistake on the site (B changed to A)

#FULL JOIN: union of 2 table
SELECT *
FROM A
FULL JOIN B ON A.key = B.key

#FULL JOIN(without intesection): union of two table without the intersection
SELECT *
FROM A
FULL JOIN B ON A.key = B.key
WHERE A.key IS NULL
OR B.key IS NULL
Comment

PREVIOUS NEXT
Code Example
Sql :: create scalar function in sql server 
Sql :: restart serial number for postgres 
Sql :: mysql datetime with timezone offset 
Sql :: SQL: get date difference in minutes 
Sql :: power bi dax is in the last 3 months 
Sql :: mysql date format 
Sql :: mysql limit 
Sql :: delete data from database sqlite android 
Sql :: average salary in sql 
Sql :: what is datetime in sql server 
Sql :: Save PL/pgSQL output from PostgreSQL to a CSV file 
Sql :: sql stored procedure update if parameter is not null 
Sql :: mysql get date from datetime 
Sql :: duplicate key value violates unique constraint in postgresql 
Sql :: sql server split string last 
Sql :: encrypt and decrypt in sql server 
Sql :: sql server delete table 
Sql :: mysql how to use FIND_IN_SET function in WHERE clause ? 
Sql :: How to insert Arabic characters into SQL database 
Sql :: count occurrences sql 
Sql :: postgresql conectar 
Sql :: sql primary key syntax 
Sql :: mssql server port 
Sql :: sql drop table 
Sql :: osm2pgsql mac 
Sql :: sqlalchemy bulk delete 
Sql :: Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. 
Sql :: reset postgres table index to next max value 
Sql :: oracle gather table statistics 
Sql :: difference between outer join and inner join sql 
ADD CONTENT
Topic
Content
Source link
Name
7+9 =