title: Insert into Table using multiple columns
body: <p>Assume that we have a table that looks like this:</p>
  
  <p><img src="https://i.stack.imgur.com/4KfNw.png" alt="enter image description here"></p>
  
  <p><code>Comma1</code> Column is a personID value, and <code>comma2</code>, <code>comma3</code>, <code>comma4</code> etc (this table is created dynamically so it can be more than 4 columns) are teamIDs.</p>
  
  <p>Now, I have another table called <code>personTeam</code> that keeps relations between <code>personids</code> and <code>teamids</code>. For example if person 13 is a member of team 3 and team 8 then in <code>personTeam</code> table should be 2 records (13,3 and 13,8).</p>
  
  <p>What i need is, using this table in the attached picture, to insert <code>personids</code> and <code>teams</code> to the <code>PersonTeam</code> table. For example for person 149 I want an insert (149,10) but for person 221 i want (221,7) ,(221,8), (221,11). </p>
  
  <p>Is there any way to work around this?
  Thank you</p>