|
|
|
|
 |
|
在祐 / 2014-06-20 / 오전 11:31:24 / 61.78.108.65
조회수 : 744
|
| [추천] [SQL] 서로 달라진 내용 비교하기 |
SELECT *
FROM
(SELECT 5 AS C_Version_N, C_HeadTerm_N, C_Modifier_A, C_English_N
FROM T_MedTerm5Eng_M
EXCEPT
SELECT 5 AS C_Version_N, C_HeadTerm_N, C_Modifier_A, C_English_N
FROM T_MedTerm6Eng_M) A
FULL OUTER JOIN
(SELECT 6 AS C_Version_N, C_HeadTerm_N, C_Modifier_A, C_English_N
FROM T_MedTerm6Eng_M
EXCEPT
SELECT 6 AS C_Version_N, C_HeadTerm_N, C_Modifier_A, C_English_N
FROM T_MedTerm5Eng_M) B
ON A.C_English_N=B.C_English_N
ORDER BY ISNULL(B.C_HeadTerm_N, A.C_HeadTerm_N)
SELECT *
FROM
(SELECT 5 AS C_Version_N, C_English_N, C_ConceptNumber_N, C_Korean_N
FROM T_MedTerm5_T
EXCEPT
SELECT 5 AS C_Version_N, C_English_N, C_ConceptNumber_N, C_Korean_N
FROM T_MedTerm6_T) A
FULL OUTER JOIN
(SELECT 6 AS C_Version_N, C_English_N, C_ConceptNumber_N, C_Korean_N
FROM T_MedTerm6_T
EXCEPT
SELECT 6 AS C_Version_N, C_English_N, C_ConceptNumber_N, C_Korean_N
FROM T_MedTerm5_T) B
ON A.C_English_N=B.C_English_N AND A.C_ConceptNumber_N=B.C_ConceptNumber_N
ORDER BY ISNULL(B.C_English_N, A.C_English_N), ISNULL(B.C_ConceptNumber_N, A.C_ConceptNumber_N)
|
|
|
|