571 reputation
514
bio website
location
age
visits member for 3 years, 4 months
seen Nov 7 at 13:55

Nov
4
awarded  Popular Question
Sep
8
awarded  Popular Question
Jul
2
awarded  Curious
May
1
awarded  Popular Question
Mar
5
asked Export to csv using db2 v10 for z/os
Jul
30
comment update statement with self join
@AndriyM- However, since it's not a single column (It's many) It really doesn't make sense to use a subquery.
Jul
30
accepted update statement with self join
Jul
30
answered update statement with self join
Jul
30
comment update statement with self join
@AndriyM, How would you use a subquery to do this?
Jul
28
awarded  Yearling
Jun
13
awarded  Notable Question
Apr
24
comment update statement with self join
@孔夫子, thanks. For some reason I thought that would cause a syntax error. However, for reference, that's not the sybase manual. It's the Sybase IQ manual, which is a different beast. Either way, it does seem to work.
Apr
24
revised update statement with self join
added 200 characters in body
Apr
24
comment update statement with self join
@JonSeigel, Thanks anyway :)
Apr
24
comment update statement with self join
@JonSeigel, specifying a table alias on the first line produces a syntax error. This does not.
Apr
24
asked update statement with self join
Apr
11
revised Why use both TRUNCATE and DROP?
deleted 4 characters in body
Feb
25
awarded  Popular Question
Nov
5
awarded  Notable Question
Jul
28
awarded  Yearling