nested query

[robert_gsfame]

tbl_user

-------------------------

name

email

 

 

tbl_ban

------------------

email

 

 

so if tbl_ban is ignored then i can use SELECT * FROM tbl_user

 

* what if i want to show all names where email is not listed in tbl_ban

* show all names where email is listed in tbl_ban

 

i try this SELECT * FROM tbl_USER WHERE email IN(SELECT email FROM tbl_ban)  for the first question and

 

SELECT * FROM tbl_USER WHERE email NOT IN(SELECT email FROM tbl_ban) for the second one..but it didnt work

 

any guides? thx in advance

 

[The Little Guy]

Try something like this (untested):

 

select *, count(tbl_ban.*) as c from tbl_user left join tbl_ban using(email) group by tbl_ban.email having c = 0;