3.4

0.0(0)
studied byStudied by 0 people
linked notesView linked note
GameKnowt Play
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/9

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.

10 Terms

1
New cards

JOIN statement

A SQL statement that combines data from two tables based on a related column between them.

2
New cards

LEFT JOIN

Selects all rows from the left table and only matching rows from the right table.

3
New cards

RIGHT JOIN

Selects all rows from the right table and only matching rows from the left table.

4
New cards

FULL JOIN

Selects all rows from both the left and right tables, regardless of whether they match.

5
New cards

INNER JOIN

Selects only the rows with matching values in both tables.

6
New cards

UNION

Combines the results of two SELECT statements into a single result set.

7
New cards

Alias

A temporary name used to make column names more understandable.

8
New cards

ON clause

Specifies the columns used for comparison in JOIN operations.

9
New cards

FROM clause

Identifies the table from which to select or delete data.

10
New cards

Columns must have comparable data types

The data types of the columns being joined need to be the same or similar for a valid JOIN operation.