CREATE OR REPLACE VIEW V_Žd“üƒf�[ƒ^
    (ƒtƒ@ƒCƒ‹‹æ•ª,“`•[”Ô�†,�s”Ô�†,Žd“ü�溰ÄÞ,Žd“ü“¾ˆÓ�溰ÄÞ,“X•Ü—p¸ÞÙ°Ìߺ°ÄÞ,•¨Œ�º°ÄÞ,Ò°¶°º°ÄÞ,
    •”º°ÄÞ,‰Ûº°ÄÞ,’S“–ŽÒº°ÄÞ,“ü‰×“ú,Œv�ã�ˆ—�“ú,“`•[“ú•t,Žx•¥�溰ÄÞ,�Á”ï�ŋ敪,
    Žæˆø‹æ•ª,�¤•iº°ÄÞ,�¤•i–¼,‹KŠi–¼,�Á”ï�Å—¦,�Á”ï�ÅŒvŽZ’PˆÊ,’è”ԋ敪,“ü—Í’PˆÊ,
    “ü�”,�”—Ê,ÊÞ×�”—Ê,’PˆÊ–¼�̋敪,’艿,’P‰¿,‹àŠz,�Á”ï�ÅŠz–¾�×,“`•[�‡Œv‹àŠz,
    “`•[�‡Œv�Á”ï�ÅŠz,“`•[’lˆø‹àŠz,‘Î�ÛŽx•¥’÷“ú,‘Î�ÛŒŽŽŸ’÷“ú,‘Î�ÛŽx•¥�ϋ敪,
    ‘Î�ÛŒŽŽŸ�ϋ敪,“E—v,�s”õ�l,‹’“_º°ÄÞ,“ü—Í’S“–ŽÒº°ÄÞ,“`•[�sŽ}”Ô,’ù�³“`•[”Ô�†,
    ”­’��溰ÄÞ,”­’�’P‰¿,�X�VµÍßÚ°Àº°ÄÞ,Žd“ü�æ”[•i�‘NO,Žd—l‚P,Žd—l‚Q)
AS
SELECT
     '1'                  as ƒtƒ@ƒCƒ‹‹æ•ª
    ,T.“ü‰×”Ô�†             as “`•[”Ô�†
    ,T.“ü‰×�s               as �s”Ô�†
    ,T.Žd“ü�溰ÄÞ           as Žd“ü�溰ÄÞ
    ,T.Žd“ü“¾ˆÓ�溰ÄÞ       as Žd“ü“¾ˆÓ�溰ÄÞ
    ,M.“X•Ü—p¸ÞÙ°Ìߺ°ÄÞ     as “X•Ü—p¸ÞÙ°Ìߺ°ÄÞ 
    ,T.Œ»�꺰ÄÞ             as •¨Œ�º°ÄÞ
    ,T.Ò°¶°º°ÄÞ             as Ò°¶°º°ÄÞ
    ,T.•”º°ÄÞ               as •”º°ÄÞ
    ,T.‰Ûº°ÄÞ               as ‰Ûº°ÄÞ
    ,T.Žd“ü’S“–º°ÄÞ         as ’S“–ŽÒº°ÄÞ
    ,T.“ü‰×“ú               as “ü‰×“ú
    ,T.Žd“üŒv�ã�ˆ—�“ú       as Œv�ã�ˆ—�“ú
    ,T.Žd“ü“`•[“ú•t         as “`•[“ú•t
    ,T.Žd“ü�溰ÄÞ           as Žx•¥�溰ÄÞ
    ,T.�Á”ï�ŋ敪           as �Á”ï�ŋ敪
    ,T.Žæˆø‹æ•ª             as Žæˆø‹æ•ª
    ,T.�¤•iº°ÄÞ             as �¤•iº°ÄÞ
    ,T.�¤•i–¼               as �¤•i–¼
    ,T.‹KŠi–¼               as ‹KŠi–¼
    ,T.�¤•i�Á”ï�Å—¦         as �Á”ï�Å—¦
    ,T.�Á”ï�ÅŒvŽZ’PˆÊ       as �Á”ï�ÅŒvŽZ’PˆÊ
    ,T.’è”ԋ敪             as ’è”ԋ敪
    ,T.“ü‰×“ü—Í’PˆÊ         as “ü—Í’PˆÊ
    ,T.¹°½“ü�”              as “ü�”
    ,T.Žd“ü�”—Ê             as �”—Ê
    ,T.Žd“üÊÞ×�”—Ê          as ÊÞ×�”—Ê
    ,T.’PˆÊº°ÄÞ             as ’PˆÊ–¼�̋敪
    ,T.’艿                 as ’艿
    ,T.Žd“ü’P‰¿             as ’P‰¿
    ,T.Žd“ü‹àŠz             as ‹àŠz
    ,T.Žd“ü�Á”ï�Å–¾�×       as �Á”ï�ÅŠz–¾�×
    ,T.Žd“ü“`•[�‡Œv‹àŠz     as “`•[�‡Œv‹àŠz
    ,T.Žd“ü“`•[�Á”ï�ÅŠz     as “`•[�‡Œv�Á”ï�ÅŠz
    ,T.Žd“ü“`•[’lˆø‹àŠz     as “`•[’lˆø‹àŠz
    ,0                    as ‘Î�ÛŽx•¥’÷“ú
    ,0                    as ‘Î�ÛŒŽŽŸ’÷“ú
    ,' '                  as ‘Î�ÛŽx•¥�ϋ敪
    ,' '                  as ‘Î�ÛŒŽŽŸ�ϋ敪
    ,T.“E—v                 as “E—v
    ,T.�s”õ�l               as �s”õ�l
    ,T.“ü—Í‹’“_º°ÄÞ         as ‹’“_º°ÄÞ
    ,T.“ü—Í’S“–ŽÒº°ÄÞ       as “ü—Í’S“–ŽÒº°ÄÞ
    ,T.“ü‰×�sŽ}”Ô           as “`•[�sŽ}”Ô
    ,T.’ù�³“`•[”Ô�†         as ’ù�³“`•[”Ô�†
    ,T.Žd“ü�溰ÄÞ           as ”­’��溰ÄÞ
    ,T.”­’�’P‰¿             as ”­’�’P‰¿
    ,T.�X�VµÍßÚ°Àº°ÄÞ       as �X�VµÍßÚ°Àº°ÄÞ
    ,T.Žd“ü�æ”[•i�‘”Ô�†Í¯ÀÞ as Žd“ü�æ”[•i�‘No
    ,T.Žd—l‚P               as Žd—l‚P
    ,T.Žd—l‚Q               as Žd—l‚Q
 FROM FE_NYUKA T,MM_TOK M
 WHERE T.Žd“ü“¾ˆÓ�溰ÄÞ=M.“¾ˆÓ�溰ÄÞ(+)
 UNION ALL
 SELECT
     '0'                  as ƒtƒ@ƒCƒ‹‹æ•ª
    ,“`•[”Ô�†             as “`•[”Ô�†
    ,�s”Ô�†               as �s”Ô�†
    ,Žæˆø�溰ÄÞ           as Žd“ü�溰ÄÞ
    ,Žd“ü“¾ˆÓ�溰ÄÞ       as Žd“ü“¾ˆÓ�溰ÄÞ
    ,“X•Ü—p¸ÞÙ°Ìߺ°ÄÞ     as “X•Ü—p¸ÞÙ°Ìߺ°ÄÞ
    ,Œ»�꺰ÄÞ             as •¨Œ�º°ÄÞ
    ,Ò°¶°º°ÄÞ             as Ò°¶°º°ÄÞ
    ,•”º°ÄÞ               as •”º°ÄÞ
    ,‰Ûº°ÄÞ               as ‰Ûº°ÄÞ
    ,’S“–ŽÒº°ÄÞ           as ’S“–ŽÒº°ÄÞ
    ,“ü‰×“ú               as “ü‰×“ú
    ,Œv�ã�ˆ—�“ú           as Œv�ã�ˆ—�“ú
    ,“`•[“ú•t             as “`•[“ú•t
    ,�¿‹�Žx•¥�溰ÄÞ       as Žx•¥�溰ÄÞ
    ,�Á”ï�ŋ敪           as �Á”ï�ŋ敪
    ,Žæˆø‹æ•ª             as Žæˆø‹æ•ª
    ,�¤•iº°ÄÞ             as �¤•iº°ÄÞ
    ,�¤•i–¼               as �¤•i–¼
    ,‹KŠi–¼               as ‹KŠi–¼
    ,�Á”ï�Å—¦             as �Á”ï�Å—¦
    ,�Á”ï�ÅŒvŽZ’PˆÊ       as �Á”ï�ÅŒvŽZ’PˆÊ
    ,’è”ԋ敪             as ’è”ԋ敪
    ,“ü—Í’PˆÊ             as “ü—Í’PˆÊ
    ,“ü�”                 as “ü�”
    ,�”—Ê                 as �”—Ê
    ,ÊÞ×�”—Ê              as ÊÞ×�”—Ê
    ,’PˆÊ–¼�̋敪         as ’PˆÊ–¼�̋敪
    ,�¬”„’P‰¿             as ’艿
    ,’P‰¿                 as ’P‰¿
    ,‹àŠz                 as ‹àŠz
    ,�Á”ï�ÅŠz–¾�×         as �Á”ï�ÅŠz–¾�×
    ,“`•[�‡Œv‹àŠz         as “`•[�‡Œv‹àŠz
    ,“`•[�‡Œv�Á”ï�ÅŠz     as “`•[�‡Œv�Á”ï�ÅŠz
    ,“`•[’lˆø‹àŠz         as “`•[’lˆø‹àŠz
    ,‘Î�ÛŽx•¥’÷“ú         as ‘Î�ÛŽx•¥’÷“ú
    ,‘Î�ÛŒŽŽŸ’÷“ú         as ‘Î�ÛŒŽŽŸ’÷“ú
    ,‘Î�ÛŽx•¥�ϋ敪       as ‘Î�ÛŽx•¥�ϋ敪
    ,‘Î�ÛŒŽŽŸ�ϋ敪       as ‘Î�ÛŒŽŽŸ�ϋ敪
    ,“E—v                 as “E—v
    ,�s”õ�l               as �s”õ�l
    ,‹’“_º°ÄÞ             as ‹’“_º°ÄÞ
    ,“ü—Í’S“–ŽÒº°ÄÞ       as “ü—Í’S“–ŽÒº°ÄÞ
    ,“`•[�sŽ}”Ô           as “`•[�sŽ}”Ô
    ,’ù�³“`•[”Ô�†         as ’ù�³“`•[”Ô�†
    ,Žæˆø�溰ÄÞ           as ”­’��溰ÄÞ
    ,Žó”­’�’P‰¿           as ”­’�’P‰¿
    ,�X�VµÍßÚ°Àº°ÄÞ       as �X�VµÍßÚ°Àº°ÄÞ
    ,Žd“ü�æ”[•i�‘NoͯÀÞ   as Žd“ü�æ”[•i�‘No
    ,Žd—l‚P               as Žd—l‚P
    ,Žd—l‚Q               as Žd—l‚Q
 FROM FB_RUISEKUK
 WHERE
 FB_RUISEKUK.ŽæˆøŽí•Ê = '02'
 ORDER BY
    “`•[”Ô�†
/