Issue querying multi-level/relational tables
I have an issue querying the tables.
I have three tables
1->profile (auth.id (FK from auth.user table), username, useremail)
2->posts (post_id, user_id (FK from profile table, post_text))
3->post_replies(reply_id, user_id (FK from profile table), post_id (FK from posts table), reply_text)
Query below works fine if there is no relationship between "posts" and the "post_replies" tables.
const { data: posts } = awaitsupabase.from('posts').select('* ,profile(username, useremail)
as soon as I add the relationship (posts->post_replies), it starts returning "null" value,
I have tried disabling RLS but no luck, as soon as I remove the relation it start returing the data.
I have three tables
1->profile (auth.id (FK from auth.user table), username, useremail)
2->posts (post_id, user_id (FK from profile table, post_text))
3->post_replies(reply_id, user_id (FK from profile table), post_id (FK from posts table), reply_text)
Query below works fine if there is no relationship between "posts" and the "post_replies" tables.
const { data: posts } = awaitsupabase.from('posts').select('* ,profile(username, useremail)
as soon as I add the relationship (posts->post_replies), it starts returning "null" value,
I have tried disabling RLS but no luck, as soon as I remove the relation it start returing the data.
