Β© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabaseβ€’4y agoβ€’
7 replies
the real phong tom 01

Can't join supabase users table on query

Hi everyone! Im facing this issue
I created a table which is called "messages"
messages
  - id int8
  - body varchar(255)
  - user_id uid 
messages
  - id int8
  - body varchar(255)
  - user_id uid 

my usecase is that i want to retrieve messages within users ( when signup it will create new record on users table ) but it doesn't work
supabase.from('messages').select("id, body, users (email)")
supabase.from('messages').select("id, body, users (email)")

I searched google and found a solution that because default user table is private, so we need to create another table (account) to store users and create a trigger for DB, everytime when signup then insert record to account table
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

Supabase API query join on multiple fields
SupabaseSSupabase / help-and-questions
4y ago
Can't Invite Users on Self-Hosted Supabase Instance
SupabaseSSupabase / help-and-questions
4y ago
Join between auth.users and another table
SupabaseSSupabase / help-and-questions
13mo ago
Can’t edit my row in supabase table
SupabaseSSupabase / help-and-questions
4mo ago