Hi all, i have some problem to solve a sql-query. (Out off topics? I don't
know.)
I have a site (a community) with a lot of members. A member
who are logged in om my site can search for other members. A logged in
member can block any other member out.
I have these table. As u can see in blocklist Table member 100102 have
blocked member 100100 out.
My question now is. How should i write my sql question.
I use a session variable session("memberNo") so i know who performing the
search.
so something like this...
Select all members from memberTable but not those who have me blocked out...
The members who have me blocked should not be in the result.
Table Member
id memberNo Nicname phone
1 100100 perea 123432
2 100101 lotta23 34342
3 100102 berta 23211
Table blocklist
id memberNo blockedMemberNo
3 100102 100100
Hope u can help out
Regards Mikael
..