Search Results for '다중업데이트'


1 POSTS

  1. 2008.06.27 다중 업데이트

다중 업데이트

Posted 2008. 6. 27. 18:04 by maxmini MAXMINI
UPDATE  TB_HMP_BOARD a
SET  a.WRITER_NICKNAME = (SELECT NICKNAME FROM TB_HMP_USER b WHERE a.WRITER_ID = b.ID)
WHERE  EXISTS (SELECT * FROM TB_HMP_USER b WHERE a.WRITER_ID = b.ID)
AND BOARD_ID='PHOTO'

Tag : , ,

Write your message and submit