API Connector : Supabase API query with filter in multiple nested table

Need help APIs
1

Hi. I am new to Supabase. I have a question regarding querying using a filter for multiple nested tables using API Connector.

I have 3 tables.

  1. material with fields = id, name, material_brand (relation to material_brand table)
  2. material_brand with fields = id, brand_name, material_type (relation to material_type table)
  3. material_type with fields = id, type_name

So far I have managed to query the material table that filters material_brand (GET /material?select=*&material_brand=eq.[id]

But what I am trying to do is to query and filter based on material_type. How can I achieve this?

Appreciate all the help, thank you.