How to get "AND" in filter in sql query builder with JMP14

[#1]

Hi,

with the sql query builder, we can add several filters like the picture below. We have always "OR" with the filters. Could it be possible to have "AND" instead of "OR"?

[#2 · Accepted solution]

To get AND just add your additional variables to the filter by selecting them and clicking the "Filter" button.

You can use shift- or ctrl-click to select multiple columns and click the filter button once.

[#3]

Thanks very much! It's OK!

[#4]

I've posted another question the same day about the sql.

M. Perkinson, have you the answer because I'm stuck!