Slide 24
Slide 24 text
Joins in query: Example
// States
{ "id": 1, "name": "California" },
{ "id": 2, "name": "Oregon" }
// Cities
{ "id": 1, "name": "Portland" },
{ "id": 2, "name": "Salem" },
{ "id": 3, "name": "San Francisco" },
{ "id": 4, "name": "Mountain View" }
// State-to-city
{ "state": 1, "city": 3 },
{ "state": 1, "city": 4 },
{ "state": 2, "city": 1 },
{ "state": 2, "city": 2 }