Hi below is a sample of my script which is also bringing null values. The reason why I added that null condition in OR is because
There are some records in output table where periodid is null and I want my result to bring all records which full fill my Date condition along with those nulls but only those nulls which fall within my date range.
But the below query is also bringing those Nulls which are outside that date range.
Any suggestions to get my desired results please ?
Select * from output c
Left outer join period p
On p. periodid = c. Periodid
Where ( p.periodstartdate > '20140401' OR
c.periodid IS NULL)