Creating a review system by joining two CMS collections

Hi there,

I’m trying to build a review system that is a 1:many relationship (one doctor: many reviews) but I’m stuck on how to retrieve the list of reviews. Right now I have:

  1. One collection of doctors
  2. One collection of reviews (this will be dynamically added as more reviews come in), with a reference key to the doctor

I’d know how to write the SQL to easily join them if they were tables, but just don’t know how to go about it in Webflow.

Thank you for your help!