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(*)');

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 JS query question

Similar Threads

Similar Threads

Similar Threads