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_source]
,NM.[news_url]
,NM.[news_status]
,NM.[RowNo]
,NM.[UpdatedON],NM.ActionName FROM NewsMaster NM INNER JOIN news_images NI on NM. news_id = NI.news_id
where NM.Created_Date = convert(varchar(10), getdate(), 102)
order by NM.news_date desc
What I have tried:
Above is my Query When i Use where NM.Created_Date = convert(varchar(10), getdate(), 102) it not working it is not getting record but when i remove Inner Join and search then it get records so please help me how to Search