I'm about to loose my mind. I checking some data and i'm getting some output I don't think I should get. Data look like:
ID : AmtPaid: Balance
1 200 0
2 200 10
Select ID from Table1 where ID =1 and (AmtPaid <>0 and Balance <>0)
The above statement does not return the data for ID 1. I was expecting output since i'm using And not OR. am I missing something.
thanks in advance.