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

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

Françoise — Mon, 09 Apr 2018 06:41:58 GMT

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"?

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

Jeff_Perkinson — Mon, 09 Apr 2018 06:58:14 GMT

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.

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

Françoise — Mon, 09 Apr 2018 07:29:51 GMT

Thanks very much! It's OK!

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

Françoise — Mon, 09 Apr 2018 07:33:30 GMT

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

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