SQL Update [message #1238] |
Sat, 13 April 2002 21:09 |
Terry Corridan
Messages: 2 Registered: April 2002
|
Junior Member |
|
|
I am having trouble with the following statement. Can you please tell me what is wrong? I get an "invalid column name" error for STAR.DIED. Thanks Terry.
UPDATE
(SELECT STAR.STARDIED
FROM MOVSTAR, MOVIE, STAR
WHERE MOVIE.YRMDE=1948 AND
STAR.STARNUMB=MOVSTAR.STARNUMB AND
MOVIE.MVNUMB=MOVSTAR.MVNUMB AND
MOVIE.DIRNUMB=2)
SET STAR.STARDIED = 2000;
|
|
|
Re: SQL Update [message #1249 is a reply to message #1238] |
Sun, 14 April 2002 23:37 |
Epe
Messages: 99 Registered: March 2002
|
Member |
|
|
Hello,
I think your syntax should be like this :
update TABLENAME
set FIELDNAME = VALUE
where WHERE-CLAUSE
Success,
epe
|
|
|