Where clause

[#1]

Hi,

following table:

ID, Count

100, 1

200, 5

300, 4

100, 5

100, 4

200, 1

If ID = 100 and Count = 1 he should not load this data but everything else.

I thought that where ID <> 100 and Count = 1 should work but in this case he delete everything which have ID 100 and count1. But I need this where clause in a combination [ID = 100 AND Count = 1]!!!

Thanks

[Chanty4u]

WHERE NOT EXISTS (id,1)

[sunny_talwar]

Try this:

Where not (ID = 100 and Count = 1);

[sunny_talwar]

This should also work:

Where ID <> 100 or Count <> 1;

[Anonymous]

Try like this?

Load

*

from YourTable where ID <> 100 or Count <> 1;

[#6]

I need a combination look at my example if Object = A and Anzahl > 2 this should not be loaded...

IF Object = A and Anzahl = 1 It must be loaded!

[#7]

!

[sunny_talwar · Accepted solution]

right then either of these should work:

Where not (Object = 'A' and Anzahl > 2);

or

Where Object <> 'A' or Anzahl <= 2;

[Chanty4u]

Where not Exists (Object = 'A' and Anzahl > 2);

[sunny_talwar]

What is your desired output for the attached qvw?