Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Hans,
Can you try below.
where ((Object = A and Anzahl <=2) or (Object<>'A'))
Thanks,
Sreeman.