Replacing my city_id with cities.name

Here is the query I'm doing so far:

const { data, error } = await supabase
    .from(health_facilities)
    .select('*, health_facility_categories!inner(*)')
    .eq('health_facility_categories.name', 'clinic')

const { data, error } = await supabase
    .from(health_facilities)
    .select('*, health_facility_categories!inner(*)')
    .eq('health_facility_categories.name', 'clinic')

const { data, error } = await supabase
    .from(health_facilities)
    .select('*, health_facility_categories!inner(*)')
    .eq('health_facility_categories.name', 'clinic')

const { data, error } = await supabase
    .from(health_facilities)
    .select('*, health_facility_categories!inner(*)')
    .eq('health_facility_categories.name', 'clinic')

Now, in my health_facilities table I have a city_id column with a foreign key to the cities table.

How can I replace the city_id with the cities.name in my result?

Replacing my city_id with cities.name

Similar Threads

Similar Threads

Similar Threads