thank you so much for responding. I really appreciate it! however I don't think it's quite right. I don't have profile_id on the chatrooms table, that's on the participants table which has the chatroom_id and profile_id. I was thinking something like this but again, I'm a noob at trying to write SQL...

(
  select
    profile_id
  from
    participants
  where
    chatroom_id = (
      select
        chatroom_id
      from
        participants
      where
        profile_id = uid()
    )

I think I'm on the right track? 😬

I think you just need to change the line from:

chatroom_id = (

to

chatroom_id in (

IN..... yes..

if your

subselect

here returns multiple values:

(
      select
        chatroom_id
      from
        participants
      where
        profile_id = uid()
    )

Then you want to say where this chatroom_id value is this following list of values

@User this did it. Thank you so much!

Awesome