Querying different schema tables

Hello, could someone help me with querying supabase using javascript sdk?
I have two tables in relationship on different schemas:
1. "public"."company_profiles"(id, account_id, location)
2. "basejump"."accounts"(id, name)

How could i query company_profiles and include basejump.accounts(name)? The relationship is on "public"."company_profile"(account_id) and "basejump"."accounts"(id)

This doesn't work for me:

const { data, error } = await supabaseClient
        .from('company_profiles')   
        .select('account_id, basejump.accounts ( name )')

const { data, error } = await supabaseClient
        .from('company_profiles')   
        .select('account_id, basejump.accounts ( name )')

Supabase•13mo ago•

5 replies

patryk

Querying different schema tables

const { data, error } = await supabaseClient
        .from('company_profiles')   
        .select('account_id, basejump.accounts ( name )')

const { data, error } = await supabaseClient
        .from('company_profiles')   
        .select('account_id, basejump.accounts ( name )')

Querying different schema tables

Similar Threads

Querying different schema tables

Similar Threads

Similar Threads

Similar Threads