Selam arkadaslar,
i need an sql
- 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