Reputation
636
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 9 14
Impact
~57k people reached

  • 0 posts edited
  • 0 helpful flags
  • 12 votes cast
Jun
10
awarded  Notable Question
May
6
awarded  Yearling
Apr
29
awarded  Favorite Question
Apr
10
awarded  Notable Question
Feb
17
awarded  Famous Question
Jan
23
awarded  Famous Question
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 :)