Why doesn't this update statement work?

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 Sat Mar 20 2004 - 20:24:12 CST