GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

SOS MYSQL

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • SOS MYSQL

    Selam arkadaslar,

    i need an sql

    1. table ids KID 1,2,3,4,5,6,7
    2.second table is user (user_ID) 1,2,3,4,5,6,7,8,9...21,25
    3.third table connection
    User ID KID
    1 2
    2 3

    what i want is , when i gave KID 2 i want something like that result
    KID USERID
    2 1
    2 null
    2 null
    2 null
    2 null
    it should list all user whether it has in 3.th table or not

    how can i do that with sql. thanks

  • #2
    LEFT OUTER JOIN.

    Comment

    Working...
    X