© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•3y ago•
3 replies
loup

Limited number of inner join during query

There is a limits of tables we can join during query ? Because making this :
const { data: movie} = await supabase
    .from('tmdb_movie')
    .select('*,translate:tmdb_movie_translation!inner(*),videos:tmdb_movie_videos(*)),genres:tmdb_movie_genre(id))')
    .eq('id', params.film)
    .eq('translate.language_id', params.lang)
    .eq('videos.iso_639_1', params.lang)
    .single();
const { data: movie} = await supabase
    .from('tmdb_movie')
    .select('*,translate:tmdb_movie_translation!inner(*),videos:tmdb_movie_videos(*)),genres:tmdb_movie_genre(id))')
    .eq('id', params.film)
    .eq('translate.language_id', params.lang)
    .eq('videos.iso_639_1', params.lang)
    .single();

I can't find genres folder, and if I put the genres before videos, I dont have videos folder
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

inner join really slow
SupabaseSSupabase / help-and-questions
4y ago
Inner Join in Dart
SupabaseSSupabase / help-and-questions
4y ago
Inner join not returning data
SupabaseSSupabase / help-and-questions
13mo ago
JS inner join match single row?
SupabaseSSupabase / help-and-questions
4y ago