query1

SELECT     y.USERID, y.BADGENUMBER, CONVERT(VARCHAR(10), x.CHECKTIME, 101) AS datelog, CONVERT(VARCHAR(8), x.CHECKTIME, 8) AS timelog,
                      x.VERIFYCODE AS verifyResult, y.NAME AS employeeName, y.DEFAULTDEPTID AS DepartmentCode, x.CHECKTYPE, RIGHT(CONVERT(VARCHAR, x.CHECKTIME, 100), 2)
                       AS waktu, RIGHT(LEFT(CONVERT(VARCHAR, x.CHECKTIME, 108), 2), 1) AS jam
FROM         dbo.CHECKINOUT AS x FULL OUTER JOIN
                      dbo.USERINFO AS y ON x.USERID = y.USERID
WHERE     (RIGHT(CONVERT(VARCHAR, x.CHECKTIME, 100), 2) = 'AM')