MySQL FULL JOIN

MySQL Tutorial

MySQL-Home MySQL-Environment setup MySQL- Workbench MySQL-Basic syntax MySQL-Operator MySQL-Data type MySQL-Comments MySQL-Create DB MySQL-Drop DB MySQL-Select DB MySQL-Create Table MySQL-Drop table MySQL-Truncate MySQL-Primary Key MySQL-Foreign Key MySQL-Null MySQL-Increment MySQL-Having MySQL-Top MySQL-Insert Statement MySQL-Select Statement MySQL-Alter Statement MySQL-Where MySQL-And & Or MySQL-Default values MySQL-Exists MySQL-Order by MySQL-View MySQL-Update Statement MySQL-Delete Statement MySQL-Like MySQL-Sort MySQL-Limit MySQL-Min MySQL-Max MySQL-Group MySQL-In MySQL-Between MySQL-Union MySQL-Count MySQL-Average MySQL-Sum MySQL-Date & Time MySQL-Import MySQL-Export MySQL-Index MySQL-Temporary MySQL-Join MySQL-Full Join MySQL-Inner Join MySQL-Left Join MySQL-Right Join MySQL-Store Procedure MySQL-Injection MySQL-PHP connection

« Previous Next »

A FULL JOIN returns all the rows from the joined tables, whether they are matched or not

FULL OUTER JOIN can potentially return very large result-sets!.

Syntax : FULL JOIN


SELECT column_name(s)
FROM table1
FULL OUTER JOIN table2
ON table1.column_name = table2.column_name
WHERE condition;

We've a table named Students and Teachers in our database that contains the following records:

Table : Students

ROLL_NO	STU_NAME	SUBJECT
1	Will	C++
2	SAM	Python
3	Rani	Node.js
4	Rim	Java
5	Micheal	JAVA
6	Lara	PHP

Table : Teachers

TECH_NO	TECH_NAME	SUBJECT	ROLL_NO
20	Kayla	PHP	6
21	Albert	Java	4
21	Albert	Java	5
22	Helen	Node.js	3
23	Anne	Python	2
24	Jaime	C++	1

The following MySQL statement will select all Students, and all Teachers :

Example : FULL JOIN



SELECT  Students.ROLL_NO, Students.NAME,Teachers.TECH_NO
FROM Students
FULL OUTER JOIN Teachers ON Students.ROLL_NO=Teachers.TECH_NO 
ORDER BY Students.NAME;

Now, after executing the above MySQL statement,

ROLL_NO	STU_NAME	TECH_NO
6	Lara	20
6	Lara	20
5	Micheal	21
5	Micheal	21
4	Rim	21
4	Rim	21
3	Rani	22
3	Rani	22
2	Sam	23
2	Sam	23
1	Will	24

« Previous Next »

C++ Tutorial	CSS Tutorial	C# Tutorial	PHP Tutorial
Java Tutorial	SQL Tutorial	JQuery Tutorial	MySQL Tutorial
HTML - Tutorial	Node.Js Tutorial	JavaScript Tutorial	Python Tutorial
MySQL Installation	Node.js Installation	XAMPP -- Installation	Python Installation
C++ - Environment Setup	Java - Environment Setup	C# - Environment Setup	Responsive Web Design

MySQL - FULL JOIN

Syntax : FULL JOIN

Table : Students

Table : Teachers

Example : FULL JOIN