© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
12 replies
Light

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
product_id text references products


await supabase
    .from('products')
    .select('*, prices(*)')
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
Could not find a relationship between 'products' and 'prices' in the schema cache


I am doing this join correctly?
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Could not find a relationship between 'lists' and 'creator'
SupabaseSSupabase / help-and-questions
4y ago
Could not find a relationship between 'messages' and 'user' in the schema cache
SupabaseSSupabase / help-and-questions
14mo ago
Could not find a relationship between 'ev_opportunities' and 'sportsbooks' in the schema cache
SupabaseSSupabase / help-and-questions
3mo ago
Could not find a relationship in the schema cache
SupabaseSSupabase / help-and-questions
13mo ago