Most of the time, there will be no record in the LEFT OUTER JOIN BELOW
FROM MyTable tbl1
LEFT OUTER JOIN MyJoinTable tblJOIN on tblJOIN.ID = tbl1.ID
So, if tblJOIN.Code comes back empty or null, set it to 0.
Just can't seem to get the syntax right to set it to 0.