title: How to get all columns from one table and one column from another table in SQLITE
body: <p>I have 2 tables with the same column names but with different data. Consider the following:</p>
  <p>Table1 Structure:</p>
  <pre><code>id, sid, text
  1,  1,   'Hello World'
  2,  1,   'Hello World again'
  3,  2,   'Hw...'
  4,  2,   'Hw2...'
  </code></pre>
  <p>And Table2:</p>
  <pre><code>id, sid, text
  1,  1,   'Hello World 2'
  2,  1,   'Hello World again 2'
  3,  2,   'Hw2...'
  4,  2,   'Hw22...'
  </code></pre>
  <p>I want to query &quot;Table1&quot; based on &quot;sid&quot;. For example, if sid is 1 then I should get 2 rows as a result with all columns from &quot;Table1&quot; but just column &quot;text&quot; from &quot;Table2&quot;. Like this:</p>
  <pre><code>id, sid, text,                  text
  1,  1,   'Hello World',        'Hello World2'
  2,  1,   'Hello World again',  'Hello World again 2'
  </code></pre>
  <p>I am trying to INNER JOIN But I get repition:</p>
  <pre><code>SELECT Table1.*, Table2.text FROM Table1 INNER JOIN Table2 ON Table1.sid = Table2.sid WHERE Table1.sid = 1;
  </code></pre>
  <p>But I am getting duplicate rows! How can I solve this? I know there are many similar questions but I could not find one with this problem.</p>