i need to implement below logic
Exclude the patients where patient date is on or 1 day prior to event date :
select [patient date], [event date] from stu_tbl
where [patient date] <> DATEADD(d, - 1, [event date])
and [patient date] <> [event date]
patients date will be multiple
will the above condition work?