Why doesn't this update statement work?
From: ck388 <google_at_timyee.com>
Date: 20 Mar 2004 18:24:12 -0800
Message-ID: <698a71bb.0403201824.5452fbd6_at_posting.google.com>
[Quoted] [Quoted] update TOE_SER_STOPGAP B INNER JOIN TOE_SER_STOPGAP A ON A.TICKETNUM = B.TICKETNUM and A.CRIS3SEQ = B.CRIS3SEQ
set B.HOLDCODES = A.HOLDCODES
Date: 20 Mar 2004 18:24:12 -0800
Message-ID: <698a71bb.0403201824.5452fbd6_at_posting.google.com>
[Quoted] [Quoted] update TOE_SER_STOPGAP B INNER JOIN TOE_SER_STOPGAP A ON A.TICKETNUM = B.TICKETNUM and A.CRIS3SEQ = B.CRIS3SEQ
set B.HOLDCODES = A.HOLDCODES
I'm simply testing out how to use JOINS with an update statement but even the simplest one I can think of does not work (ie just updating the table with the same information). I get an error "Missing SET Keyword".
Anyone have any idea why?
Thanks,
Tim :-) Received on Sun Mar 21 2004 - 03:24:12 CET