[Seasar-user:17722] Re: [dbflute-Two Tables]

[kubo]

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.
http://dbflute.sandbox.seasar.org/view/exampledb/index.html?goto=1

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 <[E-MAIL ADDRESS DELETED]>:
> 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
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-user
>
>