Journal Week 11 Day 2

What is the difference between a primary key and a foreign key

What is an Alias?

Demonstrate how you would query a join statement that would get all of a doctors patients from the following collections:

1. Primary key is a unique thing on the table you just made that is the main identifier. The foreign key is for relationships.

2. Aliasing is being more specific in querys. It is used to bring more specific info to the table.

3. SELECT patients FROM doctor.

Daily Challenge https://github.com/JordanWilker/MtM