Could not find a relationship between 'products' and 'prices'

I have two tables products and prices.
Prices has a foreign key relation to products with product_id text references products

await supabase
    .from('products')
    .select('*, prices(*)')

When I try this query it says Could not find a relationship between 'products' and 'prices' in the schema cache

I am doing this join correctly?
Was this page helpful?