how to select from supabase
my messages table is in the public schema and my users table is in the auth schema when i do the above, it returns null, why is this?
const { data, error } = await supabase
.from("messages")
.select("*, auth.users(*)");