i'm trying to run this query,
select id from tblClientID where city = 'San Francisco' and city = 'San Jose'
if i have an id that can have several cities, shouldn't it display the id? my query returns nothing.
i.e., id 5 can have city san francisco and san jose and id 4 can only have san jose. what i want to do is if san francisco and san jose is chosen, that it will only return id 5. i don't want to use 'OR' because it will return both 4 and 5.
what am i doing wrong? if this isn't possible, how do i fix it?
i'm using MS Access.