sql server - SQL Insert statement with multi-part identifier could not be bound error -

sql server - SQL Insert statement with multi-part identifier could not be bound error -

i trying execute insert statement. if record exists in table, not want record inserted. code using. maintain getting next error , unable determine why....

the multi-part identifier "tlsql.dbtl.dbo.table_sch_lead.sch_fslist_student_id" not bound. assistance appreciated.

insert 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 tlsql.dbtl.dbo.table_sch_lead not exists (select * chstlsqllead crm.dbo.chstlsqllead.tlld_fslist_studentid = tlsql.dbtl.dbo.table_sch_lead.sch_fslist_student_id);

try table alias

select sch_fslist_student_id, updated_by, updated_date, sch_lead_id, sch_lead_guid, sch_lead_status, sch_lead_received_date tlsql.dbtl.dbo.table_sch_lead schl not exists ( select * crm.dbo.chstlsqllead chl chl.tlld_fslist_studentid = schl.sch_fslist_student_id ) ;

sql-server