Can an expert take a look at line 4 below. I think my syntax is incorrect. Query analyzer is giving me the error message: The multi part identifier potion.ENTITY_ID could not be bound.
1. SELECT ENTITY_ID INTO #Temp from prad p where p.ENTITY_ID NOT IN (SELECT ENTITY_ID from mctn)
2. CREATE TABLE #Temp(ENTITY_ID varchar(64), NAME varchar(64))
3. INSERT INTO #Temp (ENTITY_ID) SELECT p.ENTITY_ID from prad p where p.ENTITY_ID NOT IN (SELECT ENTITY_ID FROM MCTN)
4. UPDATE #Temp SET #Temp.NAME = potion.NAME WHERE #Temp.ENTITY_ID = potion.ENTITY_ID)