title: Need to retrieve different records but
body: <p>I want to retrieve data without duplicated records ..the problem is that  the duplicated records have similar values in all columns except a specific column called seq_id so i can not use distinct ...  My select must have seq_id ...this is the code</p>
  
  <pre><code>SELECT x.seq_id,
         y.name,
         x.user,
         x.time_1,
         y.acc_num
  FROM table1 y,
       table2 x
  WHERE y.c_id=x.m_id;
  </code></pre>
  
  <p>The result looks like this</p>
  
  <pre><code>╔════════════════════════════════════════════════════╗
  ║ Seq_id      |name      |user      |time     |acc_n ║
  ╠════════════════════════════════════════════════════╣
  ║ 100         jim.        Ali.      10:11:30  0098   ║
  ║ 101         jim.        Ali.      10:11:30  0098   ║
  ║ 102         john        sam       04:19:30  0097   ║
  ╚════════════════════════════════════════════════════╝
  </code></pre>
  
  <p>I want it to be like </p>
  
  <pre><code>╔═════════════════════════════════════════╗
  ║ Seq_id |name  |user   |time      |acc_n ║
  ╠═════════════════════════════════════════╣
  ║ 100    jim.   Ali.    10:11:30   0098   ║
  ║ 102    john   sam     04:19:30   0097   ║
  ╚═════════════════════════════════════════╝
  </code></pre>