SQL getting started Tutorial: SQL FULL JOIN keyword usage tutorial

SQL getting started Tutorial: SQL FULL JOIN keyword usage tutorial

SQL FULL JOIN keyword
When a fully connected keyword is returned, the returned row is a table in the competition.

SQL syntax

SELECT column_name(s)FROM table_name1FULL JOIN table_name2 ON table_name1.column_name=table_name2.column_name

Let's look at an example.

 
 

  
  
 
   
 
    
P_Id
 
    
LastName
 
    
FirstName
 
    
Address
 
    
City
 
   
 
   
 
    
1
 
    
Hansen
 
    
Ola
 
    
Timoteivn 10
 
    
Sandnes
 
   
 
   
 
    
2
 
    
Svendson
 
    
Tove
 
    
Borgvn 23
 
    
Sandnes
 
   
 
   
 
    
3
 
    
Pettersen
 
    
Kari
 
    
Storgt 20
 
    
Stavanger
 
   
 
  
 
 
The "Orders" table:
 
 

  
  
 
   
 
    
O_Id
 
    
OrderNo
 
    
P_Id
 
   
 
   
 
    
1
 
    
77895
 
    
3
 
   
 
   
 
    
2
 
    
44678
 
    
3
 
   
 
   
 
    
3
 
    
22456
 
    
1
 
   
 
   
 
    
4
 
    
24562
 
    
1
 
   
 
   
 
    
5
 
    
34764
 
    
15
 
   
 
  
 
 

Now, we want to list all personnel and their orders, all orders with their persons.

We use the following SELECT statement:
SELECT Persons.LastName, Persons.FirstName, Orders.OrderNoFROM PersonsFULL JOIN OrdersON Persons.P_Id=Orders.P_IdORDER BY Persons.LastName
  
  

   
   
 
    
 
     
LastName
 
     
FirstName
 
     
OrderNo
 
    
 
    
 
     
Hansen
 
     
Ola
 
     
22456
 
    
 
    
 
     
Hansen
 
     
Ola
 
     
24562
 
    
 
    
 
     
Pettersen
 
     
Kari
 
     
77895
 
    
 
    
 
     
Pettersen
 
     
Kari
 
     
44678
 
    
 
    
 
     
Svendson
 
     
Tove
 
     
 
 
    
 
    
 
     
 
 
     
 
 
     
34764
 
    
 
   
  
  
 
The full join keyword returns all rows from the table (person) on the left, and all rows from the right table (order ). If there are "orders" listed in "persons" that do not match ",
Or are there "people" listed in "command" without a match, these lines are well listed.