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

[#2]

Hi Hans,

Can you try below.

where ((Object = A and Anzahl <=2) or (Object<>'A'))

Thanks,
Sreeman.