서브쿼리

어디선가 예제를 찾아서 해결했습니다 =.=

다른 분들도 꼭 도움이 되시길 바랍니다!

<query id="getDowntownPlaying" action="select">
    <tables>
        <table name="downtown_lobby" alias="b" />
        <table name="downtown_list" alias="a" />
    </tables>
    <columns>
        <column name="a.downtown_srl" />
    </columns>
    <conditions>
        <condition operation="equal" column="b.member_srl" var="member_srl" notnull="notnull" pipe="and" />
        <query operation="in" column="a.downtown_srl" pipe="and">
            <tables>
                <table name="downtown_list" />
            </tables>
            <columns>
                <column name="a.downtown_srl" var="downtown_srl" />
            </columns>
            <conditions>
                <condition operation="equal" column="a.status" var="status" />
            </conditions>
        </query>
    </conditions>
</query>