title: sql query displaying correct values but wrong 'id'
body: <p>I have an sql query like the following</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>select *
  from register_bs
  INNER JOIN spouse_details ON register_bs.reg = spouse_details.reg
  WHERE country NOT IN('Australia', 'USA', 'Germany', 'Canada');</code></pre>
  </div>
  </div>
  </p>
  
  <p>This query is displaying correct values for all fields except the 'id' field, it's giving some random id for every data. for example the below data:
  <a href="https://i.stack.imgur.com/rkyvt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rkyvt.png" alt="enter image description here"></a></p>
  
  <p>when i click on any button of the above data it is going to edit page with different data like below </p>
  
  <p><a href="https://i.stack.imgur.com/tM3BD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tM3BD.png" alt="enter image description here"></a></p>
  
  <p>because the id got is wrong</p>
  
  <p>As there are 900 columns in my register_bs table, I cant use field alias instead of <code>*</code>. Can anyone please tell me how to correct my statement to get the correct id? Thanks in advance</p>