try this...
select a.*, case when b.name is null then 'yes' else 'no' end as IsExistInFineTbl
from Personal as a
Left join fine as b on a.name=b.name and a.book=b.book
result...
name book IsExistInFineTbl
-----------------------------------------------
josh bk101 yes
alen bk101 yes
josh bk102 no
Happy Coding!
:)