IT 450 - Ch. 3 JOIN Operations

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/4

encourage image

There's no tags or description

Looks like no tags are added yet.

5 Terms

1
New cards

Natural JOIN

Returns matching rows and only one copy of the common join column.

2
New cards

INNER JOIN

Returns rows that satisfy the join condition.

3
New cards

LEFT OUTER JOIN

Returns all rows from the left table, including unmatched ones.

4
New cards

RIGHT OUTER JOIN

Returns all rows from the right table, including unmatched ones.

5
New cards

FULL OUTER JOIN

Returns all rows from both tables, including unmatched ones.