묻고답하기
from 절의 xml subquery 는 도대체 어떻게쓰는건가요..?
2012.04.22 00:52
메뉴얼은 오타인지뭔지.. 이렇게나와있고..
<query id="getMemberInfo" action="select">
<tables>
<table query=nfo" action="selec <table>
<table name="documents" alias="documents" />
</table>
<columns>
<column name="member_srl" alias="member_srl" />
<column name="count(*)" alias="count" />
</columns>
<groups>
<group column="member_srl" />
</groups>
</table>
<table name="member" alias="m" type="inner join">
<conditions>
<condition operation="equal" column="m.member" default="a.member_srl" />
</conditions>
</table>
</tables>
<columns>
<column name="m.member_srl" />
<column name="m.nickname" />
<column name="m.regdate" />
<column name="a.count" />
</columns>
class를 뒤져보니 condition이나 limit 등은 subquery 클래스가 별도로있지만 table 폴더엔 어디에도 포함이안되어있네요..
되기는 하는부분인지..?
어떻게써봐도 <table name 이 없으면 작동을 안하네요