topic Re: Strange results from where clause in App Development

Strange results from where clause

jelindbe — Wed, 20 Jun 2018 07:13:17 GMT

I want to extract certain years and certain age groups.

This code works to extract the age groups (ages 0-5 years):

where Alder_1agr = '5 år' or Alder_1agr = '4 år' or Alder_1agr = '3 år' or Alder_1agr = '2 år' or Alder_1agr = '1 år' or Alder_1agr = '0 år';

And this code works to extract the years I want:

where INTAAR > 2014;

But when I combine like this:

where Alder_1agr = '5 år' or Alder_1agr = '4 år' or Alder_1agr = '3 år' or Alder_1agr = '2 år' or Alder_1agr = '1 år' or Alder_1agr = '0 år'

and INTAAR > 2014;

.....the result I get is an extraction of age groups but the extraction of years dos not work (I get all the years).

I cannot figure out why.

Gysbert_Wassenaar — Wed, 20 Jun 2018 07:16:58 GMT

Try adding some parentheses so the conditions are grouped together properly:

where (Alder_1agr = '5 år' or Alder_1agr = '4 år' or Alder_1agr = '3 år' or Alder_1agr = '2 år' or Alder_1agr = '1 år' or Alder_1agr = '0 år')

and INTAAR > 2014;

jelindbe — Wed, 20 Jun 2018 07:25:44 GMT

Thank you! (How silly of me.)