title: sql insert into values The multi-part identifier could not be bound
body: <p>I am trying to run this command which shoulld append 80 rows.. but i get.</p>
  
  <p>Msg 4104, Level 16, State 1, Line 1
  The multi-part identifier "Frame.Guid" could not be bound.</p>
  
  <pre><code> INSERT  INTO  studentrecords(recordGuid, studentGuid, courseGuid, licenseGuid, repeatflag, frameGuid, coredata, framescore, timeinframe, locked, daterefreshed, dateinserted)
   VALUES     (NEWID(), '25d6e1d9-e5ce-42dd-bd6a-5956ec7cb047', '54dffd58-1af9-44cf-982e-ea0e8930878e', '00000000-1111-1111-0000-000000000000', 0, Frame.Guid,  '&lt;flags&gt;&lt;flag1&gt;1&lt;/flag1&gt; &lt;flag2&gt;1&lt;/flag2&gt; &lt;flag3&gt;1&lt;/flag3&gt; &lt;flag4&gt;1&lt;/flag4&gt; &lt;flag5&gt;1&lt;/flag5&gt;&lt;flag6&gt;1&lt;/flag6&gt;&lt;/flags&gt;&lt;StudentAnswer&gt; &lt;CorrectionHistory&gt;&lt;/CorrectionHistory&gt; &lt;/StudentAnswer&gt;', 0, 55860, 1, GETDATE(), GETDATE())
   Select Frame.Guid FROM Frame
   WHERE  (Frame.Course = '54dffd58-1af9-44cf-982e-ea0e8930878e') AND (Frame.Template &lt;&gt; '7d3a3b40-86e3-43f4-a4ca-039afdd0b7a3')
  </code></pre>