Data Connections Flashcards

1
Q

The result of _____ join is a table that contains values that have common members from both the tables.

A

Inner

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

The result of _____ join is a table that contains common members from both the tables and also all values from the left table.

A

Left Outer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

The result of ______ join is a table that contains common members from both the tables and also all values from the right table.

A

Right Outer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

The result of _____ join is a table that contains all values from both the tables.

A

Full Outer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

are used when there are multiple tables from the same data source to be used in the dashboard

A

Join

How well did you know this?
1
Not at all
2
3
4
5
Perfectly