Is this Left outer join?

If yes.

1. "addr.empid = edu.empid"-----This is join condition

2. "addr. AddType = 2"----This is filter condition

filter condition should not be mixed with join condition. But in this scenario there should not be any difference in the resultset of both.