Create policy where select matches 'abc'

[cliveportman]

I want to create a policy where the user can only select from a profiles table, where the profile matches a user in a roles table with a specific role.

Profiles:
id | col1 | col2

Roles:
id | role

I only want profiles returned if they match a row in the roles table with the role column set to 'school_teacher'.
How do I query for this within the policy creator?

[cliveportman]

Change of plan. Instead of holding everybody in the profiles table and using a roles table to manage roles, I've created different tables for different user roles. I'm using a conditional in the on_auth_user_created trigger function that puts users in the right table. It should make permissions easier and they all have different columns anyway.