Stuck with the sql query!
One table contains status and amount and users for a specific proj.
And, the query I tried as
SELECT sum(column3) AS total FROM table1 WHERE column2='wip' and column4='user1' OR column4='user2' OR column4='user3'
This query, returns the result as required. However, if I change column2='unbilled' then also it returns the same results.
I am stuck at this position, as there might be ton's of data and we required to get this column2 and these three users were the fixed users.
Can you suggest the correction in this or any refeerence?