Hello All, can anyone explain why the following SP doesn't insert any records ?, the dbo.ListNos table can be empty but the linked server always has records.

ALTER     PROCEDURE BatchUpdateListNos 
 AS
Insert into dbo.ListNos 
Select li_no As AdmitList,lux_or_uk As LuxOrUK
From lcsshare...ListNos t1 ,dbo.ListNos t2
Where t2.AdmitList
Not in
(Select li_no From lcsshare...ListNos)