SQL Getting Started Tutorial: Using the SQL full JOIN keyword tutorial

SQL Getting Started Tutorial: Using the SQL full JOIN keyword tutorial

SQL Full JOIN keyword
When a fully connected keyword is returned, the row is a table in the race.

SQL syntax

SELECT column_name (s) from
table_name1 full
JOIN table_name2 on 
table_name1.column_name=table_ Name2.column_name

Let's take a look at an example.

  
   Address 
      City 
    

 
   
   
 
    
 
     
p_id
 
     
LastName
 
     
FirstName
 
     
 
    
 
     
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 the people and their orders, all orders with them.

We use the following SELECT statement:
   

   
   
SELECT Persons.lastname, Persons.firstname, Orders.orderno from
Persons full
JOIN Orders on
persons.p_id= orders.p_id ORDER BY
Persons.lastname

   
   
 
     
     

  
      
      
 
       
 
        
LastName
 
        
FirstName
 
        
OrderNo
 
       
 
       
 
        
Hansen
 
        
Ola
 
        
22456
 
       
 
       
 
        
Hansen
 
        
Ola
 
        
24562
 
       
 
       
 
        
Pettersen
 
        
Kari
 
        
77895
 
       
 
       
 
        
Pettersen
 
        
Kari
 
        
44678
 
       
 
       
 
        
Svendson
 
        
Tove
 
        
 
       
 
       
 
        
 
        
 
        
34764
 
       
 
      
 
     
     

   
   


   
   
 
     
     

  
      
      
A fully connected keyword returns all rows from the left table (person), and all rows to the right table (order). If there are any "orders" that are listed in "people" that do not match,
  
      
      
Or whether there are "people" in the "command" without a game, these rows are listed as good.