i'm using mysql 3.23 for my DB. I am trying to run a simple mysql query with a join. Although i'm normally good at joins but for some reason i cant get this query to work and its just a simple join.
right have a users table
i just want all users from users table except 7 the one's that user_id 7 deleted from his search and now exist in user_remove_search table
this is the query that i'm using
select distinct u.*
from users u, user_remove_search urs
AND (urs.user_id=7 and u.user_id!= urs.rem_user_id)
when i run the query is shows me all the results from users table including the one's that exist in user_remove_search table again user_id 7.
anyone got any idea why this is happening?