For example, I have a table containing well log data for multiple operable units. I would like to make a query outputting a table where Operable unit=001 OR 002, AND Formation= Residuum. I would like to first select only values where operable unit equals 001 or 002, and then from those values select only those where the formation=residuum.
Currently the output from [OU] = '001' OR '002' AND [Formation] = 'Residuum', will output a table that will include other operable units as long as the formation=residuum.
I am using ArcMap 10.