foreign key select query question
Example schema
So given this kind of structure, I am trying to figure out how to do a select from interests, but have the return data include the full information of each person in the list of people id instead of just the id themselves..
I know that you can use a join to accomplish this, but have had no success when trying to build a sql query using the dashboard or using the js library. It’s clearly user error on my part as I am still learning how to structure queries so any pointers would help.
I am trying to avoid the alternative of making multiple calls for each person id after I select the interest row since that seems inefficient.
So given this kind of structure, I am trying to figure out how to do a select from interests, but have the return data include the full information of each person in the list of people id instead of just the id themselves..
I know that you can use a join to accomplish this, but have had no success when trying to build a sql query using the dashboard or using the js library. It’s clearly user error on my part as I am still learning how to structure queries so any pointers would help.
I am trying to avoid the alternative of making multiple calls for each person id after I select the interest row since that seems inefficient.
