Hi,
--Create Test Table
CREATE TABLE [dbo].[Null_Table](
[CID] [int] NULL,
[MID] [int] NULL
) ON [PRIMARY]
--Insert Sample Data
insert into Null_Table(CID,MID)
valueS (123,456)
insert into Null_Table(CID,MID)
valueS (123,Null)
insert into Null_Table(CID,MID)
valueS (123,0)
select * from Null_Table--Should be 3 Records.
SELECT * FROM Null_Table
WHERE CID IS NOT NULL
AND MID IS NOT NULL
Note:- Please help me to understand, I should receive 3 records after I run the final query, why I am getting 2 records. Please help me to understand.
Thank You.