title: Linq Join with Distinct
body: <p>I have two table 
  TABLE_A</p>
  
  <pre><code>id col_A  col_B  Col_C  DataAmt  value
  1   a       b       c     1       1
  2   a       b       c     1       1
  3   a       b       c     2       2
  4   a       b       c     2       2 
  5   a       b       c     2       2 
  </code></pre>
  
  <p>TABLE_B</p>
  
  <pre><code>id  col_A   col_B   col_C
  1    a       b        c
  2    a       b        c
  3    a       b        c
  </code></pre>
  
  <p>my linq query </p>
  
  <pre><code>from table_B in db.Table_B
  join table_A in db.table_A
  on new
  {
    col_A = table_B.col_A,
    col_B = table_B.col_B,
    col_C = table_B.col_C,
  }
  equals new
  {
    col_A = table_A.col_A,
    col_B = table_A.col_B,
    col_C = table_A.col_C,
  }
  select table_A
  </code></pre>
  
  <p>in my for i two fields, one for <strong>Value_A</strong> and <strong>Value_B</strong><br>
  on querying from table B to table A with the three colms. i have to take distinct on <strong>col_A</strong>, <strong>col_B</strong>, <strong>col_C</strong> and <strong>DataAmt</strong>, the value from <strong>value</strong> col in <strong>TABLE_A</strong> which is greater than 1 should be placed in field <strong>Value_A</strong> and others in <strong>Value_B</strong>.<br>
  I cant take distinct values and the separation of values.</p>