Guesses on #1

Post #153,408 by FuManChu 5/2/04 3:47:32 PM Reply	Guesses on #1 ...it's been a while since I had to support ASA. UPDATE child SET afield = parent.afield FROM atable child, atable parent WHERE (child.ParentID = parent.SelfID) How about: UPDATE child, parent SET child.afield = parent.afield WHERE (child.ParentID = parent.SelfID) ...if that doesn't work, try a subquery? UPDATE child SET afield = (SELECT parent.afield FROM parent WHERE parent.SelfID = child.ParentID)
Post #153,409 by FuManChu 5/2/04 3:51:03 PM Reply	Sorry, I should have put in the aliasing for you: UPDATE self as child, self as parent SET child.afield = parent.afield WHERE (child.ParentID = parent.SelfID) ...if that doesn't work, try a subquery? UPDATE self as child SET child.afield = (SELECT parent.afield FROM self as parent WHERE parent.SelfID = child.ParentID)
Post #153,453 by ChrisR 5/2/04 10:35:50 PM Reply	The subquery will work but I'm still trying to play around with the self join format ideas you gave me. thanks.
Post #153,458 by ChrisR 5/2/04 11:33:09 PM Reply	futzing around some more I can't Sybase to accept the alias in the UPDATE clause, either as a standalone (like MS) or the TableName AlisName form. I usually don't like the ANSI join syntax, as it always seems more cumbersome - especially when joining multiple tables (not to mention I've never figured out a decent way to do the indentation). In this case, though, the ANSI syntax should clarify which self is being updated: UPDATE atable\nSET afield = parent.afield\nFROM \n atable child\n INNER JOIN atable parent\n ON child.ParentID = parent.SelfID

Welcome to IWETHEY!