title: Combining resultset to get one row
body: <p>i have a query of tables which returns output as </p>
  
  <pre><code>AccessRightID   NodeID  NodeName    CanAdd  CanEdit CanDelete   CanView
  1                  2    Customer       0       0        0          1
  2                  2    Customer       1       1        0          0
  3                  2    Customer       0       0        0          0
  4                  2    Customer       0       0        0          0
  </code></pre>
  
  <p>now i want to combine and get only one row.AccessRightId is not needed.
  the final output should be like.</p>
  
  <pre><code>NodeID  NodeName    CanAdd  CanEdit CanDelete   CanView
  2       Customer        1        1        0         1
  </code></pre>
  
  <p>i.e if any value contains 1 then 1 else 0.</p>
  
  <p>plz suggest as i m new to sql.</p>