Thanks. This is very helpful. Here is what my code looks like now:
select MS_MSCRM..ContactExtensionBase, MyDB..My_Prospects
from My_MSCRM..ContactExtensionBase CEB
Where NOT EXISTS (SELECT * from MyDB..Prospects IRFP Where IRFP.dynamicsID=CEB.new_ContactIdentifier)
I'm running into
two one issue: 1. It states that it "Cannot resolve the collation conflict between 'Latin1_General_CI_AI' and 'SQL_Latin_General_CP1_CI_AS' in the equal to operation." (Used COLLATE DATABASE_DEFAULT to rectify).
2. It is also complaining about "multi-part identifiers" - which I know is usually related to not aliasing the tables - but I did?