´ç½Å¿¡°Ô·Î ¶°³ª´Â ²Þ¼Ó¿©Çà - ²Þ¼Ó³ª¶ó(http://www.inyourdream.net) ÀÔ±¹Çϱâ | ¿µÁÖ±Ç ½Åû
  • ¸öºÎ¸² °ñ¶ó°ñ¶ó
  • ¼Ò±Ù¼Ò±Ù
  • µµ¶õµµ¶õ
  • ³«¼­¸¶´ç
  • Âø°¢ÇѾÆÀÌ
  • ¼ýÀÚ¸ÂÃß±â
  • ¼Ò¿øºô±â
  • ÈçÀû³²±â±â
  • ²Þ¼Ó¿©Çà
  • Ä£±¸Áý ³î·¯°¡±â
  • ¸ðµÎµå¸²´ÔÀÇ È¨
  • î¤éÞ´ÔÀÇ È¨
  • Çö¿ì´ÔÀÇ È¨
  • º°¾ÆÇØ´ÔÀÇ È¨
  • ÇÞ»ì´ÔÀÇ È¨
  • À̳ª´Ï´ÔÀÇ È¨
  • À¯¸®¾Ë´ÔÀÇ È¨
  • ³È³ÈÀÌ´ÔÀÇ È¨
  • ²ÀÁö´ÔÀÇ È¨
  • ´ë¼º´ÔÀÇ È¨
  • î¤éÞ / 2014-06-20 / ¿ÀÀü 11:31:24 / 61.78.108.65
    Á¶È¸¼ö : 659
    [Ãßõ] [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 À̳»·Î ÀÔ·ÂÇϼ¼¿ä À̸§ : Æнº¿öµå :