So the gist of the story is that I would like to combine queries to yield a result. Basically, I have something that looks like this:
((Food = Chicken) OR (Farm = Fresh)) AND ((Produce = Corn) OR (Eggs = Healthy))
However, a query like this gives one or the other rather than what I want which is records with both Chicken and Corn or Chicken and Healthy or Fresh and Healthy or Fresh and Corn. Am I writing the script incorrectly?
أكثر...
((Food = Chicken) OR (Farm = Fresh)) AND ((Produce = Corn) OR (Eggs = Healthy))
However, a query like this gives one or the other rather than what I want which is records with both Chicken and Corn or Chicken and Healthy or Fresh and Healthy or Fresh and Corn. Am I writing the script incorrectly?
أكثر...