SELECT  itemID, 
      mnu_code,
      bl.ID
      FROM lu_mnu_code lum
      LEFT OUTER JOIN bl ON bl.ID = lum.itemID
WHERE :MENUCODE = lum.mnu_code;