i am selecting data from table
SELECT NM.[news_id],
NI.image_Path
,CONVERT(varchar(50), [news_date],106) as news_date
,NM.[news_head]
,NM.[short_news]
,NM.[news_descrip]
,NM.[news_prod]
,NM.[prodduct_id]
,NM.[country]
,NM.[countrycode]
,NM.[news_url]
,NM.[news_source]
,NM.[news_status]
,NM.flag
,NM.Status
,NM.[RowNo]
,NM.[UpdatedON],NM.ActionName FROM NewsMaster NM INNER JOIN news_images NI on NM. news_id = NI.news_id
where --Created_Date = convert(varchar(10), getdate(), 102)
Flag IS NULL
order by NM.news_date desc
What I have tried:
above is my query i want to know how to give condition
if my value is null flag column and value in status column null then i found data
but when my value is null in flag column and value is 5 in my status column then data not found so please help how to use condition in where condition