Joins in SQL Flashcards
1
Q
What are joins in SQL?
A
Joins are used to combine records from two or more tables based on a related column between them.
2
Q
What are the different types of joins in SQL?
A
There are four main types of joins in SQL:
Inner Join
Left Join
Right Join
Full Join
3
Q
Inner Join
A
Returns the records matching in both tables
4
Q
Left Join
A
Returns all left table records and matched right table records.
5
Q
Right Join
A
Returns all right table records and matched left table records.
6
Q
FULL JOIN
A
Returns all records from both tables with matched records.
