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 1

2 1

3 0

4 1