Ha, MemberCB cb = new MemberCB(); cb.setupSelect_MemberStatus(); //cb.query.setMemberId("AAA"); List<Member> memberList = memberBhv.selectList(cb); for (Member member : memberList) {    // columns of MEMBER table    Integer memberId = member.getMemberId();    String memberName = member.getMemberName();    // columns of MEMBER_STATUS table    MemberStatus memberStatus = member.getMemberStatus(); // *Point!    String memberStatusName = memberStatus.<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">getMemberStatusName();    ... }</blockquote><div> by using cb.query.setXXXXXX(), i can set conditions only for Member Tabel. </div><div> How can i set the condition for memberstatus table? Is it Possible in DBFlute ConditionBean? Thanks in advance, トマス  </div> <div class="gmail_quote">2009/6/12 thomas <<a href="mailto:jp.mcy.10@gmail.com">jp.mcy.10@gmail.com</a>> <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> Hai, Thanks for your reply...<div class="im"> /= = = = = = = = = = = = = = = = = = = = = = = = = = = = MemberCB cb = new MemberCB(); cb.setupSelect_MemberStatus(); // *Point! List<Member> memberList = memberBhv.selectList(cb); for (Member member : memberList) {    // columns of MEMBER table    Integer memberId = member.getMemberId();    String memberName = member.getMemberName();    // columns of MEMBER_STATUS table    MemberStatus memberStatus = member.getMemberStatus(); // *Point!    String memberStatusName = memberStatus.<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">getMemberStatusName();    ... }</blockquote> </div>This is what i want... Thank you very much. Regards, トマス<div><div></div><div class="h5"> <div class="gmail_quote">On Fri, Jun 12, 2009 at 1:03 AM, kubo <<a href="mailto:dbflute@gmail.com" target="_blank">dbflute@gmail.com</a>> wrote: <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hello, Sorry, it's about time for me to go to bed... I can not make my reply for several hours. (until next morning in Japan) So I'm trying to write what I can write now. If you want to select MEMBER and MEMBER_STATUS, (MEMBER and MEMBER_STATUS : many-to-one) you can implement in condition-bean like this: /= = = = = = = = = = = = = = = = = = = = = = = = = = = = MemberCB cb = new MemberCB(); cb.setupSelect_MemberStatus(); // *Point! List<Member> memberList = memberBhv.selectList(cb); for (Member member : memberList) {    // columns of MEMBER table    Integer memberId = member.getMemberId();    String memberName = member.getMemberName();    // columns of MEMBER_STATUS table    MemberStatus memberStatus = member.getMemberStatus(); // *Point!    String memberStatusName = memberStatus.getMemberStatusName();    ... } - - - - - - - - Please watch the method 'ConditionBeanBasicTest.test_basic_Tx()'. <a href="https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example/src/test/java/com/example/dbflute/basic/dbflute/howto/jp/ConditionBeanBasicTest.java" target="_blank">https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example/src/test/java/com/example/dbflute/basic/dbflute/howto/jp/ConditionBeanBasicTest.java</a> = = = = = = = = = =/ If you want to select MEMBER and PURCHASE, (MEMBER and PURCHASE : one-to-many) you can implement in condition-bean like this: /= = = = = = = = = = = = = = = = = = = = = = = = = = = = MemberCB cb = new MemberCB(); // At first, it selects the list of Member. ListResultBean<Member> memberList = memberBhv.selectList(cb); // And it loads the list of Purchase with its conditions. memberBhv.loadPurchaseList(memberList, new ConditionBeanSetupper<PurchaseCB>() {    public void setup(PurchaseCB cb) {        cb.query().setPurchaseCount_GreaterEqual(2);        cb.query().addOrderBy_PurchaseCount_Desc();    } }); // *Point! for (Member member : memberList) {    // columns of MEMBER table    Integer memberId = member.getMemberId();    String memberName = member.getMemberName();    // list of purchase for current member.    List<Purchase> purchaseList = member.getPurchaseList(); // *Point!    for (Purchase purchase : purchaseList) {        // columns of Purchase table        Integer purchaseId = purchase.getPurchaseId();        ...    } } - - - - - - - - Please watch the method 'BehaviorMiddleTest.test_loadReferrer_Tx()'. <a href="https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example/src/test/java/com/example/dbflute/basic/dbflute/howto/jp/BehaviorMiddleTest.java" target="_blank">https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example/src/test/java/com/example/dbflute/basic/dbflute/howto/jp/BehaviorMiddleTest.java</a> = = = = = = = = = =/ <div><div></div><div> On Thu, Jun 11, 2009 at 11:56 PM, kubo<<a href="mailto:dbflute@gmail.com" target="_blank">dbflute@gmail.com</a>> wrote: > Hello, this is jflute > > I'm sorry that I can not accurately understand your question. > What does it mean "more than one table"? > > Let me show this example database for our communication. > <a href="http://dbflute.sandbox.seasar.org/view/exampledb/index.html?goto=1" target="_blank">http://dbflute.sandbox.seasar.org/view/exampledb/index.html?goto=1</a> > > Does it means, for example, > "MEMBER and MEMBER_STATUS"? > (related two tables) > > select mbr.MEMBER.MEMBER_ID >          mbr.MEMBER.MEMBER_NAME >          mstat.MEMBER_STATUS_NAME >  from MEMBER mbr >    left outer join MEMBER_STATUS mstat >      on mbr.MEMBER_STATUS_CODE = mstat.MEMBER_STATUS_CODE > > > 2009/6/11 thomas <<a href="mailto:jp.mcy.10@gmail.com" target="_blank">jp.mcy.10@gmail.com</a>>: >> hai, >> >> I want to clarify one thing. >> Is there any other way to select values from more than one table without >> using outside SQL? >> >> If there is any way how can i get the values from more than one table? >> >> Regards, >> トマス >> >> _______________________________________________ >> Seasar-user mailing list >> <a href="mailto:Seasar-user@ml.seasar.org" target="_blank">Seasar-user@ml.seasar.org</a> >> <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a> >> >> > _______________________________________________ Seasar-user mailing list <a href="mailto:Seasar-user@ml.seasar.org" target="_blank">Seasar-user@ml.seasar.org</a> <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a> </div></div></blockquote></div> </div></div></blockquote></div>