Home Forums Career Certification showing Mutual friends through query RE: showing Mutual friends through query

  • June 14, 2012 at 2:29 pm

    #1501280

    i think either of these will do what you are asking:

    SELECT *

    FROM tbl_usermain FirstGuy

    INNER JOIN tbl_user_friends FirstFriends

    ON FirstGuy.user_id = FirstFriends.user_id

    LEFT OUTER JOIN tbl_usermain SecondGuy

    on FirstFriends.user_id = SecondGuy.user_id

    INNER JOIN tbl_user_friends SecondFriends

    on SecondGuy.user_id = SecondFriends.user_id

    WHERE FirstFriends.user_id = SecondFriends.user_id

    AND FirstGuy.user_id = 42 --Bob

    AND SecondFriends..user_id = 38 --Jeff

    SELECT *

    FROM tbl_usermain FirstGuy

    INNER JOIN tbl_user_friends FirstFriends

    ON FirstGuy.user_id = FirstFriends.user_id

    INNER JOIN tbl_user_friends SecondFriends

    on FirstFriends.user_id = SecondFriends.user_id

    WHERE FirstFriends.user_id = SecondFriends.user_id

    AND FirstGuy.user_id = 42 --Bob

    AND SecondFriends..user_id = 38 --Jeff

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!