What sql select query can I use to display posts from one friend when user clicks on one of their friends' profile after login?

Question

What Sql select query can I use in PHP to display posts from one friend when user clicks friend's photo or username after user login?

Answer 1

I tried that before I posted the question and it didn't give me the results I wanted. I want it to show posts from one friend after clicking on their profile. I'm trying to join the users table, followers table, and posts table to show posts from one friend.