Update Statement

[Tim2525]

Hi All,

This should be a very easy one. I'm having trouble getting my update statement to run. I come from an Oracle background so this stuff is still greek to me.

UPDATE catentry
SET catentry.field4 = 'KM'
From manurel, catentry, catentdesc
WHERE manurel.manunbr IN (2495,1135)
AND manurel.manunbr = catentry.field2  
AND catentdesc .catentry_id = catentry.catentry_id

Your assistance would be most appreciated.

TIA,
T

 

[rbod]

the Update syntax goes like :
UPDATE table_name
SET table_name.column_name=value
WHERE condition

you could probably improvise on this:
update catentry
set catentry.field4 = 'KM'
where catentry.field2 IN
(select catentry.field2
from manurel, catentry, catentdesc
where manurel.manunbr IN (2495,1135) and
manurel.manunbr = catentry.field2 and
catentdesc .catentry_id = catentry.catentry_id)

 

[Tim2525]

Thanks much rbod. That did it.

T