Skip to content
Advertisement

SQLite: How to see people that aren’t my friend, but are friends with my friends

I have a database in DB Browser where I have two tables;

Example data from User

Example data from Friends

So my question is, how do I make a query that Displays People that I’m not friends with, but my friends are friends with them. It’s so I can find new friends basically.

Advertisement

Answer

You can join multiple times:

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement