title: Insert into query inserting null into 1st column instead of data into specified column
body: <p>I am trying to perform a simple insert into, and for some reason it is trying to insert a null value into the 1st column, instead of inserting data into the column I have specified in the query. </p>
  
  <pre><code>INSERT INTO EquipInfo (OrgID)
  SELECT OrgID from Org_Import
  </code></pre>
  
  <p>Cannot insert the value NULL into column 'MAC', table 'C:\ILoveYouStackOverFlow\Inventory.MDF.dbo.EquipInfo'; column does not allow nulls. INSERT fails.</p>
  
  <p>The EquipInfo table is already in place, MAC is the primary key, and is the only column that doesn't allow nulls. My Org_Import table has one column with no null values in it. </p>
  
  <p>Do I have to provide a value for every single column? I basically just want to append OrgID from Org_Import onto the end of EquipInfo.</p>
  
  <p>All I want to do is add a new column on the end of my EquipInfo table. MAC is short for MAC address, it will controls network access on a vlan.</p>