<?xml version="1.0" encoding="UTF-8" ?>
<jsp:root
	xmlns:jsp="http://java.sun.com/JSP/Page"
	xmlns:og="hybs-taglib.tld"
	version="2.0">
<jsp:directive.page language="java" contentType="text/html; charset=UTF-8" />

<!-- タグリブ⇒既存ラベル重複削除 -->
<!-- 既存のラベルと同一の場合は、タグリブラベルを削除しておきます。 例:refresh , editName とか -->
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" stopZero="true">
	select A.SYSTEM_ID,A.CLM,
			A.LNAME AS BEFORE,'{@ARROW}',B.LNAME AS AFTER,A.UNIQ
	from  GEA08 A inner join GEA08 B
				on    A.CLM       = B.CLM
				and   A.LANG      = B.LANG
				and   A.LNAME    != B.LNAME
	where A.SYSTEM_ID = 'GF'
	and   B.SYSTEM_ID in ( 'GF' , '**' )
	and   A.KBLBL     = 'A'
	and   B.KBLBL    != 'A'
	and   A.LANG      = 'ja'
	and   A.FGJ       = '1'
	and   B.FGJ       = '1'
</og:query>

<og:value key="lblKey" value="C" />

<og:hidden name="SQL">
	DELETE FROM GEA08
	WHERE UNIQ      = [UNIQ]
	AND   SYSTEM_ID = 'GF'
	AND   CLM       = [CLM]
	AND   KBLBL     = 'A'
</og:hidden>
</jsp:root>
