1. Learn
    2. /
  2. Courses
    3. /
  3. Querying a PostgreSQL Database in Java
Connected

Exercise

The first join

CityBook Libraries wants to display book categories alongside search results. Only books with assigned categories should appear in the results.

Join the categories table to enrich the book data. The HikariSetup class is already configured for you.

Instructions

100 XP
  • Complete the query to join with the categories table using category_id.
  • Select the proper join type to show only books that have a category.