© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•13mo ago•
4 replies
NaanBalboa

Join between auth.users and another table

Hi, I created a table called services with a user_id column that is related to the auth.user.id column. I checked the documentation to learn how to retrieve both the user information and the service data in a single query. However, when I attempt to do this, I encounter the following error: "Could not find a relationship between 'services' and 'users' in the schema cache."

const { data: services, error: servicesError } = await supabase
        .from('services')
        .select('*, users(*)')
const { data: services, error: servicesError } = await supabase
        .from('services')
        .select('*, users(*)')


I also tried using auth.user(*) but without success.

Thank you.
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

Join through another table
SupabaseSSupabase / help-and-questions
4y ago
Deleted the auth.users table
SupabaseSSupabase / help-and-questions
4y ago
Can't join supabase users table on query
SupabaseSSupabase / help-and-questions
4y ago
Foreign key from Prisma table to auth.users
SupabaseSSupabase / help-and-questions
4y ago