Hi,
I believe the query below should help.
SELECT A.BADGENUMBER, A.EMPNAME, A.DESIG, B.PTIME
FROM TBL_EMP A
LEFT JOIN TBL_PUNCH B ON B.BADGENUMBER = A.BADGENUMBER AND B.SN = A.SN
WHERE A.SN='4550962200016'
Try that, and maybe check out this really helpful article on CodeProject
Visual Representation of SQL Joins[
^]
Thanks,