SQL Join

Which join returns records that have matching values in both tables?

• Full Join

• Inner Join

• Left Join

• Right Join

Which join returns all records from the left table, and the matched records from the right?

• Full Join

• Inner Join

• Left Join

• Right Join

Which join returns all records when there is a match in either left or right table?

• Full Join

• Inner Join

• Left Join

• Right Join

Which join returns all records from the right table, and the matched records from the left table?

• Full Join

• Inner Join

• Left Join

• Right Join

Which records will be displayed when we used Full Join?

• 
• 
• 
• 

Which records will be displayed when we used Left Join?

• 
• 
• 
• 

Which records will be displayed when we used Inner Join?

• 
• 
• 
• 

Which records will be displayed when we used Right Join?

• 
• 
• 
•