So, as the title says, trying to join four tables.
The purpose of the script is to:
Get the username of members being "followed" from table called following
Find the status updates of members in step one from table called status
Retrieve all comments on status from step two from table named status_comments
Get the members avatar location from table named users
I am posting from my phone at the moment, so cannot include the existing code....
I have no problems joining three of the four tables, just adding the fourth is killing me...
Some schema is below:
Members being "followed": following.member
Being "followed" by: following.followed_by
Status ID: status.id
Status "owner": status.member
Members who posted a comment: status_comments.comment_by
Commenters avatar: users.pic
Even just showing me the way to structure this query with psuedo code would be a great help!
Thank you in advance!