IWETHEY v. 0.3.0 | TODO
1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / The subquery will work
Post #153,453
by ChrisR
5/2/04 10:35:50 PM
Reply
New 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
New 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
     T-SQL to T-SQL Conversion - (ChrisR) - (13) - May 2, 2004, 03:17:27 PM EDT
         Guesses on #1 - (FuManChu) - (3) - May 2, 2004, 03:47:32 PM EDT
             Sorry, I should have put in the aliasing for you: - (FuManChu) - (2) - May 2, 2004, 03:51:03 PM EDT
                 The subquery will work - (ChrisR) - (1) - May 2, 2004, 10:35:50 PM EDT
                     futzing around some more - (ChrisR) - May 2, 2004, 11:33:09 PM EDT
         OT and completely beyond the scope - (drewk) - (7) - May 2, 2004, 04:05:46 PM EDT
             Scott's the one that pointed me in the Sybase direction - (ChrisR) - (6) - May 2, 2004, 10:39:53 PM EDT
                 Cool, and a question - (drewk) - (1) - May 3, 2004, 07:30:11 AM EDT
                     Spelling impaired - (ChrisR) - May 3, 2004, 10:36:09 AM EDT
                 Parent/child IDs - (admin) - (3) - May 3, 2004, 08:34:43 AM EDT
                     When would that be? - (drewk) - (2) - May 3, 2004, 08:53:29 AM EDT
                         That's a big one. - (admin) - (1) - May 3, 2004, 09:08:24 AM EDT
                             OK, but why not ... - (drewk) - May 3, 2004, 09:12:48 AM EDT
         Answer on the Sybase equivalent of REPLACE - (ChrisR) - June 11, 2004, 01:21:07 AM EDT

Calvin Klein kind of, North Carolina.
40 ms