derailed from the topic and question.....

do not use more than two instances of given table...

try to give output like this.

PersonID IsImproper

1 ...

yes the task could have been done this way but she wants all the records to be called improper if any of the date is not proper

can anyone perform this task with two tables only....

Hi Divya, it gud..

you just can minimize the query length a little by removing the highlighted text...

SELECT *,

(SELECT CASE

...