can someone tell me what is wrong with this update query

UPDATE tblprocessInfo
SET ProgDate = (
SELECT TermInformation.ProgDate
FROM tblProcessInfo, TermInformation
WHERE TermInformation.Term = tblProcessInfo.Term AND TermInformation.SID = tblProcessInfo.SID);


Basically, both tables processInfo and termInformation are similar, except terminformation has extra field "ProgDate".
So what I did, i created that field in tblProcessInfo to import from termInformation.ProgDate.
Now of course the processInfo.progdate is empty and termInformation.Progdate has the stuff...
So I created the query as you can see, but doesnt work..

any solutions or ideas?!

thanks

Update tableA ta
set column =
(select column from tableB where key = ta.key)

While your query as written makes logical sense, it will cause consternation for most database engines (MS-SQL included). The problem is that you've used the same table alias twice in a single context, but most optimizers won't realize that, so they'll generate a Cartesian join! You can probably simplify the query down to:This only uses the tblprocesInfo alias once, and it should prevent the confusion.

-PatP

thanks..
that makes sense...

I will try it later on