title: SQL: How to reuse an id in another row of the same table?
body: <p>I'm sql newbie &amp; work on a receipt database.</p>
  
  <pre><code>CREATE TABLE Food(
                  id INTEGER PRIMARY KEY NOT NULL IDENTITY,
                  name VARCHAR (30) NOT NULL,
                  entity VARCHAR (30) NOT NULL,
                  alternative_ID INTEGER NOT NULL
                  );
  </code></pre>
  
  <p>How can I insert e.g an apple and use the id of banana for the alternative_ID column?</p>