If the columns ending with "ID" are the related columns:

SELECT
     EmpID
   , StdID
   , HRID
   , RecDate
   , RecDate
   , VaFrmDate
   , VaToDate
FROM
   EMployee
FULL JOIN
   Student ON EmpID = StdID
FULL JOIN
   HR ON StdID = HRID;


FULL JOIN or FULL OUTER JOIN returns all the data that matches or doesn't match. Not knowing which table is the parent I used this type of join. With more info a better solution could be posted.