Update in tables with joins.

[Alpenk]

I'm trying to update an empty field in a table using the update statment. The table has a number of joins and the update statement comes up with an error when I enter the main table to update. should i be including the joins here as well? I get the following error:

Server: Msg 208, Level 16, State 1, Line 178
Invalid object name 'TD_EXTRACT'.
Server: Msg 208, Level 16, State 1, Line 178
Invalid object name '#Neil.Mortgage '.

The code im using...

DECLARE Alpen_Cursor CURSOR FOR

SELECT TDE.Merged_Fund _Desc,
TDE.MORTGAGE,
TDE.Client_Main _Surname,
HAT.[Last_Delq_Bucke t],
HAT.[Current_Balance],
HAT.[Possession_Date],
M56.ASSNAM AS [Possession Agent],
TDP.REGION,
HAT.Litigation_ Status,
HAT.MORTGAGE_ST ATUS,
A34SC.PROGCLOSE ,
Cast('space' AS VARCHAR(100)) AS Prog_Point_list


FROM REPT_SOURCE_ME_ 01.dbo.TD_EXTRA CT TDE

INNER JOIN REPT_SOURCE_ME_ 01.dbo.TD_ARREA RS HAT
ON TDE.MORTGAGE = HAT.MORTGAGE

INNER JOIN REPT_SOURCE_ME_ 01.dbo.[ACM41] ACM
ON TDE.MORTGAGE = ACM.MORTGAGE

INNER JOIN REPT_SOURCE_ME_ 01.dbo.[MAM56] M56
ON ACM.LITPOSSAGEN T = M56.ASSCDE

INNER JOIN REPT_SOURCE.dbo .[ACT34StageC] A34SC
ON ACM.MORTGAGE = A34SC.MORTGAGE

INNER JOIN REPT_SOURCE.dbo .[MAM16] M16
ON ACM.LITSOLICITO R = M16.SOLCDE

INNER JOIN REPT_SOURCE_ME_ 01.dbo.TD_PROPE RTY TDP
ON TDE.MORTGAGE_NO = TDP.MORTGAGE_NO

WHERE A34SC.PROGPNT IN ('AUC','AUO','M PS','NRC','OLP' ,'ORC','POS','R AR','RCO','REC' ,'RMP','ROF','R OS','ROW','RPO' ,'TIC','VPO')
AND HAT.Litigation_ Status = 'possession'
AND HAT.MORTGAGE_ST ATUS = 'live'
AND A34SC.PROGCLOSE IS Null


GROUP BY TDE.Merged_fund _Desc,
TDE.MORTGAGE,
TDE.Client_Main _Surname,
HAT.[Last_Delq_Bucke t],
HAT.[Current_Balance],
HAT.[Possession_Date],
M56.ASSNAM,
TDP.REGION,
M16.SOLNAME,
HAT.Litigation_ Status,
HAT.Mortgage_St atus,
A34SC.PROGCLOSE ,
ACM.LITSOLICITO R

HAVING (((HAT.Litigati on_Status) = 'Possession') AND ((HAT.MORTGAGE_ STATUS) = 'Live') AND ((A34SC.PROGCLO SE) IS Null));

OPEN Alpen_Cursor
FETCH NEXT FROM Alpen_Cursor

CLOSE Alpen_cursor
DEALLOCATE alpen_cursor

UPDATE
SET TD_EXTRACT.Prog _Point_list = #neil.PROGPNT + ','
FROM TD_Extract

INNER JOIN #Neil.Mortgage
ON TD_Extract.Mort gage = #Neil.Mortgage
AND #Neil.PROGPNT = Alpen_Cursor.PR OGPNT