| Subject | Re: Just for the records | 
|---|---|
| Author | Roman Rokytskyy | 
| Post date | 2004-05-31T18:30:45Z | 
> I, erroneously, put this in a SP and the Firebird accepted with noSecond "name" is considered an alias and is very legal syntax. For
> error message, but the questions is, is it possible to to this? (the
> table's name appears twice), would that generate an exception in
> runtime?
>
> UPDATE SERVICOS SERVICOS SET VALOR_TOTAL = VALOR_TOTAL + :xVALOR_ITEM;
example you can do following:
UPDATE myLongTable t1
SET
t1.myColumn = :someVar
WHERE
t1.someId = (
SELECT anotherId
FROM anotherTable t2
WHERE t2.otherCol = :anotherVar)
Roman