MI-L MI-L: Update Column Based on Value in Different Row

[Declan Troy]

Not sure if this is possible or just a syntax issue. Is there a way 
to update a column using a value in a different row.

Something to the effect of     update mytable set X = Y + Z(ROWID-1)

Any suggestions?

declan

---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9039