Lesson 7: Getting Data From Two Tables

Question 1

Table Relationships

Answer 1

Tables are linked or related through the PK and FK to create the relationship between two or more tables.

Question 2

Join

Answer 2

A JOIN clause is used to combine rows from two or more tables, based on a related column between the tables. The default join statement is an INNER JOIN.

Question 3

Inner Join

Answer 3

The INNER JOIN keyword selects rows that have matching values in both tables. The INNER JOIN is the default join.

Question 4

One-to-one Relationship

Answer 4

The PK column in table1 relates to the FK column in one row in table2.

Question 5

One-to-many Relationship

Answer 5

The PK column in table1 can relate to the FK column in many rows in table2