...
WHERE
(tbl.mr.[sysCode]=55)

just leave out the "AND ..."