title: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the
body: <pre><code>CREATE PROCEDURE sm.Prnataccuserdivisionmappinglist @ENTITYCODE INT, 
                                                      @USERCODE   INT 
  WITH encryption 
  AS 
    BEGIN 
        SELECT D.flddivisioncode, 
               D.flddivisionname, 
               M.fldcompanydivisionno, 
               (SELECT flddivisioncode 
                FROM   sm.tblnataccuserdivisionmap 
                WHERE  flddivisioncode = D.flddivisioncode 
                       AND fldentitycode = @ENTITYCODE 
                       AND fldusercode = @USERCODE)AS FLDMAPSTATUS 
        FROM   sm.tbldivisiondetails D 
               INNER JOIN sm.tblnataccdivisionmapping M 
                       ON M.flddivisioncode = D.flddivisioncode 
                          AND fldcompanyentitycode = @ENTITYCODE 
    END 
  </code></pre>