-------- debug information ---------
Select TB_TOPICS.TOPIC_ID
,TB_TOPICS.TOPIC_TYPE
,TB_TOPICS.TOPIC_SUBJECT
,TB_TOPICS.TOPIC_TEXT
,To_Char(TB_TOPICS.EXP_DATE, 'mm/dd') As KAI_DATE
,To_Char(TB_TOPICS.EXP_DATE, 'd') As KAI_WEEK
,TB_TOPICS.JIGEN_CD
,TB_TOPICS.OLD_ROOMCD
,TB_TOPICS.NEW_ROOMCD
,TB_TOPICS_TARGET.COM_ID
,M_COMMUNITY.COM_NM
From CNS.TB_TOPICS
,CNS.TB_TOPICS_TARGET
,CNS.M_COMMUNITY
Where TB_TOPICS.TOPIC_ID = TB_TOPICS_TARGET.TOPIC_ID
And TB_TOPICS_TARGET.DEL_FLG = '0'
And TB_TOPICS_TARGET.COM_ID Like 'J%'
And TB_TOPICS_TARGET.COM_ID = M_COMMUNITY.COM_ID
And M_COMMUNITY.DEL_FLG = '0'
And TB_TOPICS.DEL_FLG = '0'
And TB_TOPICS.TOPIC_TYPE In ('2','3','4')
And TB_TOPICS.TOPIC_ID = '20190614387598'
Order By TB_TOPICS.EXP_DATE, TB_TOPICS.JIGEN_CD, TB_TOPICS_TARGET.COM_ID

Array
(
)
山梨大学市民開放授業 []
山梨大学
OpenCourseInformation
市民開放授業情報
指定された情報はありません｡

[戻る]