SELECT
KBN.区分 AS KBN,
KBN.区分コード AS KBN_CD,
KBN.区分名 AS KBN_NM,
KBN.区分略称 AS KBN_KNJ,
KBN.区分カナ AS KBN_KNA,
KBN.親子区分 AS OYAKO_KBN,
KBN.上位区分1 AS JOUI_KBN1,
KBN.上位区分2 AS JOUI_KBN2,
KBN.上位区分3 AS JOUI_KBN3,
KBN.上位区分4 AS JOUI_KBN4,
KBN.上位区分5 AS JOUI_KBN5,
KBN.上位区分6 AS JOUI_KBN6,
KBN.上位区分7 AS JOUI_KBN7,
KBN.上位区分8 AS JOUI_KBN8,
KBN.上位区分9 AS JOUI_KBN9,
U1.区分名 AS KBN_NM1,
U2.区分名 AS KBN_NM2,
U3.区分名 AS KBN_NM3,
U4.区分名 AS KBN_NM4,
U5.区分名 AS KBN_NM5,
U6.区分名 AS KBN_NM6,
U7.区分名 AS KBN_NM7,
U8.区分名 AS KBN_NM8,
U9.区分名 AS KBN_NM9,
U1.区分略称 AS KBN_KNJ1,
U2.区分略称 AS KBN_KNJ2,
U3.区分略称 AS KBN_KNJ3,
U4.区分略称 AS KBN_KNJ4,
U5.区分略称 AS KBN_KNJ5,
U6.区分略称 AS KBN_KNJ6,
U7.区分略称 AS KBN_KNJ7,
U8.区分略称 AS KBN_KNJ8,
U9.区分略称 AS KBN_KNJ9,
KBN.文字データ1 AS CHAR_DATA1,
KBN.文字データ2 AS CHAR_DATA2,
KBN.文字データ3 AS CHAR_DATA3,
KBN.文字データ4 AS CHAR_DATA4,
KBN.文字データ5 AS CHAR_DATA5,
KBN.文字データ6 AS CHAR_DATA6,
KBN.文字データ7 AS CHAR_DATA7,
KBN.区分レベル AS KBN_LVL,
KBN.登録者コード AS INS_SHA_CD,
KBN.登録日 AS INS_DTS,
KBN.登録時刻 AS INS_TIME,
KBN.更新者コード AS UPD_SHA_CD,
KBN.更新日 AS UPD_DTS,
KBN.更新時刻 AS UPD_TIME
FROM "T_M区分" KBN
LEFT JOIN "T_M区分" U1
ON KBN.上位区分1 = U1.区分コード
AND KBN.区分 = U1.区分
LEFT JOIN "T_M区分" U2
ON KBN.上位区分2 = U2.区分コード
AND KBN.区分 = U2.区分
LEFT JOIN "T_M区分" U3
ON KBN.上位区分3 = U3.区分コード
AND KBN.区分 = U3.区分
LEFT JOIN "T_M区分" U4
ON KBN.上位区分4 = U4.区分コード
AND KBN.区分 = U4.区分
LEFT JOIN "T_M区分" U5
ON KBN.上位区分5 = U5.区分コード
AND KBN.区分 = U5.区分
LEFT JOIN "T_M区分" U6
ON KBN.上位区分6 = U6.区分コード
AND KBN.区分 = U6.区分
LEFT JOIN "T_M区分" U7
ON KBN.上位区分7 = U7.区分コード
AND KBN.区分 = U7.区分
LEFT JOIN "T_M区分" U8
ON KBN.上位区分8 = U8.区分コード
AND KBN.区分 = U8.区分
LEFT JOIN "T_M区分" U9
ON KBN.上位区分9 = U9.区分コード
AND KBN.区分 = U9.区分
WHERE
1=1
AND KBN.区分 = :i_kbn
AND KBN.区分コード = :i_cd
帮我调整sql文,添加上位区分名称,根据上位区分1-9 ,查询格式为‘レベル1 90000 共通’这里边レベル1-9是固定的,按照顺序。
90000 这个是上位区分,共通 这个是区分名。请帮我修改sql,如果是空的什么也不显示