© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•13mo ago•
30 replies
RBGDEV

Supabase JS query question

i have a power_point table with a column for "media_id", it can be null or it can be a refernce to the media tables id column.

im trying to make this call

const { data, error } = await supabase.from('power_point).select('*, media:media(*)');
const { data, error } = await supabase.from('power_point).select('*, media:media(*)');


This works but returns nothing if media_id is NULL for all rows. Is there anyway to get that data when applicable but still return everything else without it when not?

Or what should my approach be here?
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

Question about supabase-js client capabilities
SupabaseSSupabase / help-and-questions
6mo ago
supabase-js query with nested date compare
SupabaseSSupabase / help-and-questions
6mo ago
Supabase query
SupabaseSSupabase / help-and-questions
4y ago
Question about Supabase gotrue-js lock warning
SupabaseSSupabase / help-and-questions
3w ago