Query all posts but not include the posts that posted by blocked users

General
1

Hello,

I got stuck at this problem now.

I have 3 tables now: BlockedUsers, Posts, Users now. When my app start, it fetch all the posts in Posts table now. But this user has blocked many users and blocked users can be found in BlockedUsers table. When the app fetch posts, I want it exclude the posts that created by blocked users.

I am not very familiar with SQL, it might be very simple but please give me some helps.

(Platform iOS)

Best regards,
Weinan

2

Weinan,

This question is outside of the free support as it is more on the side of “how do i…?” type of question. Please consider purchasing a support plan which would let you get help from Backendless for this type of issues.

Regards,
Mark