Reversing an Inner Join
Posted on 2004-08-26
I have a query that looks like this:
SELECT fname, member.id, filename, friendID,memberFriends.memID, statusID
INNER JOIN memberFiles on member.id = memberfiles.memID
INNER JOIN memberFriends on member.id = memberFriends.friendID
WHERE memberFriends.memID = 19 OR memberFriends.FriendID = 19
AND ID != 19
Basically, it establishes a relationship between two members. It works, returning the "friends" of the member who
s ID is specified. The problem is that when their friend's profile is accessed that member does not show up in the query.
In other words, I need to be able to find all members who friendID matches a memberID, which is the reverse of what this query produces.
Does that make sense?