|
|
|
|
 |
|
在祐 / 2010-11-25 / 오후 1:09:10 / 71.199.3.234
조회수 : 511
|
| [기타] [SQL] 조인을 이용한 UPDATE |
UPDATE T_DSGeneric_M
SET T_DSGeneric_M.C_PID_N=generic.분류기호,
T_DSGeneric_M.C_GenericID_N=generic.일반명코드,
T_DSGeneric_M.CNT=generic.CNT,
T_DSGeneric_M.C_InsuID_N=generic.표준코드,
T_DSGeneric_M.C_Complex_N=generic.복합제,
T_DSGeneric_M.C_GenericName_N=generic.성분명,
T_DSGeneric_M.C_Dose_N=generic.규격,
T_DSGeneric_M.C_Unit_N=generic.단위,
T_DSGeneric_M.C_KATC_N=generic.KATC,
T_DSGeneric_M.C_Indication_N=generic.효능효과,
T_DSGeneric_M.C_Review_N=generic.용법용량,
T_DSGeneric_M.C_XML4Review_N = generic.XML4REVIEW
FROM generic INNER JOIN
T_DSGeneric_M ON generic.일반명코드 = T_DSGeneric_M.C_GenericID_N |
|
|
