Hi
i want to select the values from my table where a column must contains some value. So i wrote this
Select * from RG_TAB where CMCode = 4 and CMCode = 5
This query not giving me any result but
Select * from RG_TAB where CMCode = 4 Or CMCode = 5
is giving me result.
I am confused. What is happening. What should be the query?
Thanks and regards,
sbv