PART 2 SQL JOINS

0.0(0)
studied byStudied by 0 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/4

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

5 Terms

1
New cards

JOIN

clause combines rows from two or more tables based on a common column.

2
New cards

INNER JOIN

returns rows that have matching values in both tables

3
New cards

LEFT JOIN

returns all rows from the left table and the matched records from the right table. If there is no match from the right side, the result is NULL.

4
New cards

RIGHT JOIN

returns all rows from the right table and the matched records from the left table. If there is no match from the left side, the result is NULL.

5
New cards

FULL JOIN

returns all records when there is a match on either the left or right table. If there is no match, the missing side will contain NULL.