당신에게로 떠나는 꿈속여행 - 꿈속나라(http://www.inyourdream.net) 입국하기 | 영주권 신청
  • 몸부림 골라골라
  • 소근소근
  • 도란도란
  • 낙서마당
  • 착각한아이
  • 숫자맞추기
  • 소원빌기
  • 흔적남기기
  • 꿈속여행
  • 친구집 놀러가기
  • 모두드림님의 홈
  • 在祐님의 홈
  • 현우님의 홈
  • 별아해님의 홈
  • 햇살님의 홈
  • 이나니님의 홈
  • 유리알님의 홈
  • 냠냠이님의 홈
  • 꼭지님의 홈
  • 대성님의 홈
  • 在祐 / 2014-06-20 / 오전 11:31:24 / 61.78.108.65
    조회수 : 669
    [추천] [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)
    Byte * 200 Byte 이내로 입력하세요 이름 : 패스워드 :