<?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" />

<og:head headType="query" />
<jsp:directive.include file="/jsp/custom/query_info.jsp" />
<og:comment
	system	= "GF:エンジンサンプル"
	pgid	= "GF6360"
	title	= "テーブル結合"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>

<form method="POST" action="forward.jsp" target="RESULT" onSubmit="timeSet();">
<table border="0" frame="border" >
<tr>
	<og:select name="action" lbl="Action">
		<og:option value="UNION_ALL"  lbl="UNION_ALL"  />
		<og:option value="UNION"      lbl="UNION"      />
		<og:option value="INTERSECT"  lbl="INTERSECT"  />
		<og:option value="MINUS"      lbl="MINUS"      />
		<og:option value="DIFFERENCE" lbl="DIFFERENCE" />
		<og:option value="UNION_CLM"  lbl="UNION_CLM"  />
		<og:option value="UNION_VAL"  lbl="UNION_VAL"  />
		<og:option value="GROUP"      lbl="GROUP"      />
	</og:select>
	<og:column name="maxRowCount"  value="100" lbl="MaxRowCount" size="5" />
	<og:space />
</tr>
<tr>
	<og:column name="unionClms"    lbl="unionClms"   />
	<og:column name="modifyClms"   lbl="modifyClms"  />
	<og:select name="noSideEffect" lbl="noSideEffect">
		<og:option value="false" lbl="false" />
		<og:option value="true"  lbl="true"  />
	</og:select>
</tr>
<tr>
	<og:column name="masterKeys"  lbl="masterKeys"  />
	<og:column name="diffKeys"    lbl="diffKeys"    />
	<og:select name="useDiffData" lbl="useDiffData">
		<og:option value="true"  lbl="true"  />
		<og:option value="false" lbl="false" />
	</og:select>
</tr>
</table>

<table>
<tr><td>
<fieldset><legend><strong>Master</strong></legend>
<table>
<tr>
	<og:column name="MDBID"  lbl="DBID"  value="" codeKeyVal="{@DBID_INFO}" />
	<og:column name="MTBLID" lbl="TBLID" value="" size="5" />
	<og:select name="MSCP" lbl="SCP">
		<og:option value="session"  lbl="session"  selected="selected" />
		<og:option value="request"  lbl="request"  />
	</og:select>
</tr>
<tr>
  <td colspan="6">
	<table><tr>
	  <og:textarea name="MSQL" lbl="SQL" rows="5" cols="35" useRealTimeCheck="false" >
		{@USER.LASTSQL}
	  </og:textarea>
	</tr></table>
  </td>
</tr>
</table>
</fieldset>
</td>
<td>
<fieldset><legend><strong>Slave</strong></legend>
<table>
<tr>
	<og:column name="SDBID"  lbl="DBID"  value="" codeKeyVal="{@DBID_INFO}" />
	<og:column name="STBLID" lbl="TBLID" value="" size="5" />
	<og:select name="SSCP" lbl="SCP">
		<og:option value="session"  lbl="session"   />
		<og:option value="request"  lbl="request"  selected="selected"/>
	</og:select>
</tr>
<tr>
  <td colspan="6">
	<table><tr>
	  <og:textarea name="SSQL" lbl="SQL" rows="5" cols="35" useRealTimeCheck="false" >
	  </og:textarea>
	</tr></table>
  </td>
</tr>
</table>
</fieldset>
</td></tr>
</table>

<og:queryButton />
</form>

<jsp:directive.include file="/jsp/common/htmlend.jsp" />
</jsp:root>
