title: SQL Insert statement with multi-part identifier could not be bound error
body: <p>I am trying to execute an insert statement.  If the record already exists in the table, I do not want the record inserted.  This is the code I am using.  I keep getting the following error and I am unable to determine why....  </p>
  
  <blockquote>
    <p>The multi-part identifier
    "TLSQL.DBTL.dbo.Table_Sch_Lead.Sch_FSList_Student_ID" could not be
    bound.  Any assistance would be greatly appreciated.</p>
  </blockquote>
  
  <pre><code>INSERT INTO CRM.dbo.CHStlsqlLead 
      (tlld_FSList_StudentID,
      tlld_Updated_By,
      tlld_Updated_Date,
      tlld_schLeadID,
      tlld_SchLeadGUID,
      tlld_LeadStatus,
      tlld_SchLeadRecdDate)
      SELECT  Sch_FSList_Student_ID,
              Updated_By, 
              Updated_Date,
              Sch_Lead_ID,
              Sch_Lead_GUID, 
              Sch_Lead_Status, 
              Sch_Lead_Received_Date 
      FROM TLSQL.DBTL.dbo.Table_Sch_Lead
      WHERE 
      NOT EXISTS (SELECT * FROM CHStlsqlLead
      WHERE CRM.dbo.CHStlsqlLead.tlld_FSList_StudentID = TLSQL.DBTL.dbo.Table_Sch_Lead.Sch_FSList_Student_ID);
  </code></pre>