I am currently working on a mapping project and only need 8 tenements out of many to appear. I have gone into the query builder to complete this and unfortunately it will not work. Into the builder a put Tenement = 'E59/1002' AND Tenement = 'E59/1421'. It verifies but no records are found. I am not sure why this is happening as this method has always worked for me before when i need to select multiple tenements.
Any help?
Best Answer
All you need to do is change AND to OR. Because AND is a valid logical operator the validation passes. So technically the query is correct, it just will not return any records.