Joining Metadata

In the last two episodes, you learned about how database tables are glued together through their relationships. Let’s see in action by writing SQL queries to fetch posts and associated post metadata in one query. You’ll see how INNER JOIN is different than LEFT JOIN. You’ll learn how to grab specific metadata with your query, such as a subtitle. Then you’ll do the same experiment with the users and user metadata tables. Let’s write some SQL.