I have a query wherin I do a date comparison with another date.
This works fine except in cases where the date is NULL (when there is no
Select * from Employee where status ='Present' and emp_id=10 and date >
( select max(date) from Employee where emp_id=10 and status not in ('Work from home','On Site') )
This works great when the inner query returns a value .But when its NULL I get an empty set in the whole query as well .