[SQL] Update + Select

view plaincopy to clipboardprint?

1. UPDATE BLOCK_LOC_INFO A  
2.     SET A.TAG_ID =   
3.         (SELECT  
4.             TAG_ID  
5.          FROM (SELECT   
6.                   BLOCK_ID,   
7.                   rownum TAG_ID  
8.                FROM  
9.                    CMI_MST_BLOCK) B  
10.          WHERE B.BLOCK_ID = A.BLOCK_ID)  

UPDATE BLOCK_LOC_INFO A SET A.TAG_ID = (SELECT TAG_ID FROM (SELECT BLOCK_ID, rownum TAG_ID FROM CMI_MST_BLOCK) B WHERE B.BLOCK_ID = A.BLOCK_ID) 다른 테이블에서 셀렉트한 결과를 업데이트 할 때 썼던 쿼리문.