<jsp:directive.page pageEncoding="UTF-8" />
<og:query command="NEW" debug="{@debug}" maxRowCount="0">
		select A.SYSTEM_ID , A.TBLSYU , A.TABLE_NAME , A.SEQNO , A.CLM
				, A.NAME_JA , A.CLS_NAME , A.USE_LENGTH
				, A.DATA_DEFAULT , A.NOT_NULL , A.FGCOM , A.BIKO
				, B.NOJUN*1000+A.SEQNO as NOJUN
		from GF05 A inner join GF84 B
					on  A.SYSTEM_ID  = B.SYSTEM_ID
					and A.TBLSYU     = B.TBLSYU
					and A.TABLE_NAME = B.TABLE_NAME
					and A.FGJ        = '1'
	<og:where>
		<og:and value = "A.SYSTEM_ID	=    '{@SYSTEM_ID}'"	/>
		<og:and value = "A.TBLSYU		=    '{@TBLSYU}'"		/>
		<og:and value = "A.TABLE_NAME	like '{@TABLE_NAME}%'"	/>
		<og:and value = "B.CDIKOU		in  ( {@CDIKOU} )" multi="true"	/>
	</og:where>
		order by A.SYSTEM_ID,A.TBLSYU,B.NOJUN*1000+A.SEQNO
</og:query>

<!-- NOJUN(対応順)は、全テーブルカラムを通して、連番にしています。テーブル単位の連番は、SEQNO です。-->
<!-- og:tableFilter classId="SEQRESET" keys="SEQ_CLM,CLEAR_CLM" vals="NOJUN,TABLE_NAME" selectedAll="true" / -->
