Could somebody tell me why this UPDATE statement is not working?

UPDATE "MEMORY\tbData" A SET A.Name = B.Name
FROM "MEMORY\tbData" A
LEFT OUTER JOIN TB_Security B
ON B.Symbol = A.Security

SOLVED:  I lost 3 hours because of this stupid typing mistake.

Regards,
Abdulaziz Jasser

"Abdulaziz Jasser" <jasser@cyberia.net.sa> wrote in message
news:39AD6915-A915-4ABF-BEE8-8C7FCACEB6E6@news.elevatesoft.com...
> Could somebody tell me why this UPDATE statement is not working?
>
> UPDATE "MEMORY\tbData" A SET A.Name = B.Name
> FROM "MEMORY\tbData" A
> LEFT OUTER JOIN TB_Security B
> ON B.Symbol = A.Security
>

Why in the world use a left outer join for an update like this, where you
SET a value to the a value on the joined table?  There might be a reason,
but it certainly is not obvious. Why do you need access to the rows in A
that have no match in B?

Robert