10 Replies Latest reply: Feb 15, 2016 7:32 AM by sreemannarayana g RSS

    Where clause

    Hans Müller

      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