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

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

Original text of this message