danno80 Posted April 15, 2008 Share Posted April 15, 2008 Hi guys, I am new to using sql and am having trouble with getting a query right It involves 3 tables: users - id (primary key unique) friends - (junction table) player_id, friend_id (both indexed to users:id) ignores - (junction table) player_id, ignored_id (both indexed to users:id) I can get what I want with multiple queries but have been unable to crack getting it with one I want to get all users who are neither friends nor ignores for a given user so I have user with id of say 1: I want to get all users from users and then exclude those appearing under friend_id and ignored_id in the two junction tables that have player_id of 1 thanks if anyone can help Quote Link to comment https://forums.phpfreaks.com/topic/101143-joining-query/ Share on other sites More sharing options...
fenway Posted April 15, 2008 Share Posted April 15, 2008 You can use a LEFT JOIN, then restict on friend_id IS NULL and ignored_id IS NULL. Quote Link to comment https://forums.phpfreaks.com/topic/101143-joining-query/#findComment-517657 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.