[RESOLVED] Joining tables issue

[Mark_Nordstrom]

I have 3 tables

members, pfields, profile_friends

They all have a field that is the same like member_id to link BUT profile_friends wont have you in it if you have no friends so how can I join all 3 even if your member_id doesnt exist in profile_friends ?

[Weedpacket]

You'd use either a "LEFT JOIN" or a "RIGHT JOIN" (look them up) depending on whether the profile_friends table is joined on the left or the right.

[Mark_Nordstrom]

have to be doing something wrong.

SELECT m., p. FROM members AS m, pfields_content AS p RIGHT JOIN profile_friends AS f ON friends_member_id WHERE member_group_id='4' AND m.member_id=p.member_id

It shows 2 of every name not grouping the members/pfields_content tables.

[Mark_Nordstrom]

So I've realized what I need is more complicated.

SELECT name, m.member_id, p.member_id, posts, friends_friend_id, last_visit FROM members AS m, pfields_content AS p LEFT JOIN profile_friends ON friends_friend_id='$member_id' WHERE member_group_id='4' GROUP BY m.member_id

What I need is to take 3 tables member, pfields_content I wanna join them ON member_id Then I wanna take them 2 tables and join profile_friends ON friends_member_id The only issue is again if you have no friends it wont find your member_id in profile_friends.

Thinking about it more I only need profile_friends.friends_friend_id='$member_id' But it needs to group member_id and friends_member_id if friends_friend_id=2 then echo yes if anything else echo no