So I have two HubDB Tables
One called experts one called expert_reviews
expert reviews has a foreign table link to experts
I have my Hubl set up to get all the details for three random experts like so
{% for row in hubdb_table_rows("experts","&orderBy=random()&limit=3") %}
{{ row.name }}
{% endfor %}
etc but now I want to return 1 review from each returned expert but I’m not sure how to reference them I have tried something like this
{% for review in hubdb_table_rows("expert_reviews","expert={{row.sb_id}}&orderBy=random()&limit=1") %}
{% endfor %}
but that doesn’t work can anyone give me any tips