Languages
[Edit]
EN

MySQL - JOIN list + SQL Query

7 points
Created by:
Dirask JS Member
3430

MySQL - JOIN list + SQL Query

VisualisationSQL Query

INNER JOIN

SELECT *
FROM table_a A
JOIN table_b B ON A.key = B.key

LEFT OUTER JOIN

SELECT *
FROM table_a A
LEFT JOIN table_b B ON A.key = B.key

RIGHT OUTER JOIN

SELECT *       
FROM table_a A
RIGHT JOIN table_b B ON A.key = B.key

FULL OUTER JOIN

SELECT * FROM table_a A
LEFT JOIN table_b B ON A.key = B.key
UNION
SELECT * FROM table_a A
RIGHT JOIN table_b B ON A.key = B.key

LEFT OUTER JOIN with exclusion

SELECT  *
FROM table_a A
LEFT JOIN table_b B ON A.key = B.key
WHERE B.key IS NULL

RIGHT OUTER JOIN with exclusion

SELECT *
FROM table_a A
RIGHT JOIN table_b B ON A.key = B.key
WHERE A.key IS NULL

FULL OUTER JOIN with exclusion

SELECT * FROM table_a A
LEFT JOIN table_b B ON A.key = B.key
WHERE B.key IS NULL 
UNION
SELECT * FROM table_a A
RIGHT JOIN table_b B ON A.key = B.key
WHERE A.key IS NULL

MySQL

MySQL - JOIN list + SQL Query
Native Advertising
­čÜÇ
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

ÔŁĄ´ŞĆ­čĺ╗ ­čÖé

Join