SELECT * FROM CI_MD_MENU_ITEM WHERE SUB_MENU_NAME IN (SELECT MENU_NAME FROM CI_MD_MENU WHERE MENU_TYPE_FLG='SUB');