Multi Condition Filter

[Laynlowz]

Hello

I would like to add a filter that both values need to be met to populate data. so in my screen shot 000001896 would be ignored because the STOP_SEQ is just 1, but 000001895 has STOP_SEQ 1 and STOP_SEQ 2 so I would like to only see 000001895 populate along with both stops. How would I go about doing this?

I tried STOP_SEQ IN ('1') and STOP_SEQ in ('2') which didn't show errors, but it didn't work.


shipment         STOP_SEQ         FACILITY
000001896           1                    100

000001895           1                    200
000001895           2                    300

[dougp]

STOP_SEQ IN ('1') and STOP_SEQ in ('2') returns 0 results, right?  You can't have two different values in the same column on one row, so both conditions can't be met.  It's like saying FRUIT = 'APPLE' AND FRUIT = 'BANANA'.  It can't be both.

If you want to show only the shipments that has more than one STOP_SEQ:

Code Select Expand

count (distinct [STOP_SEQ] for [shipment]) > 1