Try this--
select userid, name, (Case when Exist(Select 1 from tbl_leave where tbl_leave.UserID=tbl_login.userid and Convert(varchar(11),tbl_leave.fromdate,106)=convert(varchar(11),getdate(),106)) then 'absent' else 'present' end) as status from tbl_login
--Pankaj