<div>$B?9OF$5$s!"5WJ]$5$s(B</div><div><br></div><div>$B0J2<$@$HB?J,Bg>fIW$@$H;W$$$^$9!#(B</div><div><br></div>select dflocal.ID as ID, dflocal.NAME as NAME, dflocal.NAMECODE as NAMECODE<br> , dfrelation_0.ID as ID_0, dfrelation_0.CODEKIND as CODEKIND_0<br>
, dfrelation_0.CODE as CODE_0, dfrelation_0.NAME as NAME_0<br> from HOGE_TBL dflocal<br> left outer join NAME_TBL dfrelation_0 on dflocal.NAMECODE =<br>dfrelation_0.CODE <div>where (dfrelation_0.CODEKIND = '80'$B!K(B</div>
<div><br></div><div>$B;VB<(B<br><br><div class="gmail_quote">2010$BG/(B5$B7n(B27$BF|(B10:21 k.moriwaki <span dir="ltr"><<a href="mailto:kuno53196224@gmail.com">kuno53196224@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
$B5WJ]$5$s(B<br>
$B$*@$OC$K$J$j$^$9!"?9OF$G$9!#(B<br>
<br>
$B2sEz$"$j$,$H$&$4$6$$$^$9!"$3$s$J$KAa$/BP1~$7$FD:$1$k$H$O;W$$$^$;$s$G$7$?!#(B<br>
0.8.9.16-RC2 $B$G<+F0@8@.$7$?%=!<%9$G4|BTDL$j$N(BSQL$B$,=PNO$5$l$k;v$,3NG'$G$-$^$7$?!#(B<br>
<br>
> # $B2r7h$7$?$N$G!"(BMS Access$B$G$b$=$l$J$j$K(B<br>
> # CB$B$,MxMQ$G$-$k$h$&$K$J$C$F$$$^$9!#(B<br>
$B$3$l$K$D$$$F<ALd$J$N$G$9$,!"6HL3E*(Bone-to-one $B$O%5%]!<%HBP>]30$G$7$g$&$+!)(B<br>
$B;n$7$K$d$C$F$_$?$H$3$m0J2<$N$h$&$J(BSQL$B$,=PNO$5$l%(%i!<$K$J$j$^$7$?!#(B<br>
$B%(%i!<$NFbMF$O!V(Bleft outer join $B!A(B on $B!A(B and $B!A(B $B!W$N(Band$B0J9_$NItJ,$G(B<br>
$B!V7k9g<0$,%5%]!<%H$5$l$F$$$^$;$s!W$H$J$j$^$9!#(B<br>
<br>
$B;d$b(BMSAccess$B$N9=J8$K$O>\$7$/$J$$$?$a$I$&$$$&Iw$K=$@5$7$?$iNI$$$+$o$+$i$J$$$N$G$9$,!"(B<br>
$B$H$j$"$($:0J2<$N(Bsql$B$K(Bwhere$B$rDI2C$7!"(Band$B0J9_$N>r7o$r(Bwhere$B$KDI2C$7$?$i<hF@$G$-$k$h$&$K$J$j$^$7$?!#(B<br>
<br>
----- SQL $B$3$3$+$i(B<br>
select dflocal.ID as ID, dflocal.NAME as NAME, dflocal.NAMECODE as NAMECODE<br>
, dfrelation_0.ID as ID_0, dfrelation_0.CODEKIND as CODEKIND_0<br>
, dfrelation_0.CODE as CODE_0, dfrelation_0.NAME as NAME_0<br>
from (HOGE_TBL dflocal<br>
left outer join NAME_TBL dfrelation_0 on dflocal.NAMECODE =<br>
dfrelation_0.CODE and dfrelation_0.CODEKIND = '80')<br>
----- SQL $B$3$3$^$G(B<br>
<br>
<br>
2010$BG/(B5$B7n(B26$BF|(B15:53 kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>>:<br>
<div><div></div><div class="h5">> $B5WJ](B(jflute)$B$G$9!#(B<br>
><br>
> $B$3$s$K$A$O!"?9OF$5$s(B<br>
><br>
> "0.8.9.16-RC2" $B$K$F!"H?1G$7$F$_$^$7$?!#(B<br>
> MS Access $BMxMQ;~$@$1(B($B<+F0E*$K(B)$B1i;;;R$,(B<br>
> $B@Z$jBX$o$k$h$&$K$J$C$F$$$k$O$:$G$9!#(B<br>
> (Java$BHG$N(BExample$B$G$O3NG'$,<h$l$F$$$^$9(B)<br>
><br>
> RC$B$O!"0J2<$+$i%@%&%s%m!<%I$7$F2<$5$$!#(B<br>
><br>
> // DBFlute.NET$B$N:G?7%P!<%8%g%s(B<br>
> <a href="http://dbflute.net.sandbox.seasar.org/ja/environment/newest.html" target="_blank">http://dbflute.net.sandbox.seasar.org/ja/environment/newest.html</a><br>
><br>
><br>
> #<br>
> # $B$A$J$_$K!"(BSNAPSHOT$B$r$4MxMQ$H$$$&$3$H$G!"(B<br>
> # $B$4B8CN$+$b$7$l$^$;$s$,!"(BJOIN$B<~$j$NLdBj$r(B<br>
> # $B2r7h$7$?$N$G!"(BMS Access$B$G$b$=$l$J$j$K(B<br>
> # CB$B$,MxMQ$G$-$k$h$&$K$J$C$F$$$^$9!#(B<br>
> # Java$BHG$N(B dbflute-msaccess-example $B$G!"(B<br>
> # @Ignore$B$K$J$C$F$$$J$$5!G=$OMxMQ$G$-$^$9!#(B<br>
> #<br>
><br>
> 2010/5/26 k.moriwaki <<a href="mailto:kuno53196224@gmail.com">kuno53196224@gmail.com</a>>:<br>
>> $B?9OF$H?=$7$^$9!#(B<br>
>><br>
>> $B!&4D6-(B<br>
>> .NET Framework 3.5<br>
>> s2container.net-1.3.17<br>
>> dbflute-0.8.9.16-SNAPSHOT<br>
>><br>
>> $B!&>u67(B<br>
>> ConditionBean$B$G(BNotEqual$B$r;HMQ$7$?>l9g!"=PNO$5$l$k(BSQL$B$N1i;;;R$,!V(B!=$B!W$K$J$j$^$9$,(B<br>
>> MSAccess$B$N>l9g$O!V(B<>$B!W$J$N$G9=J8%(%i!<$K$J$C$F$7$^$$$^$9!#(B<br>
>> MSAccess$B$O=`%5%]!<%H$G(BConditionBean$B$O$[$\;H$($J$$$H$OM}2r$7$F$$$^$9$,!"(B<br>
>> $BC1=c$J(BSQL$B$NH/9T$O(BConditionBean$B$rMxMQ$7$?$$$N$G!"(BMSAccess$B$N>l9g$O!V(B<>$B!W(B<br>
>> $B$r=PNO$9$k$h$&BP1~$7$FD:$/$3$H$O2DG=$G$7$g$&$+!)(B<br>
>> _______________________________________________<br>
>> seasar-dotnet mailing list<br>
>> <a href="mailto:seasar-dotnet@ml.seasar.org">seasar-dotnet@ml.seasar.org</a><br>
>> <a href="https://ml.seasar.org/mailman/listinfo/seasar-dotnet" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-dotnet</a><br>
>><br>
> _______________________________________________<br>
> seasar-dotnet mailing list<br>
> <a href="mailto:seasar-dotnet@ml.seasar.org">seasar-dotnet@ml.seasar.org</a><br>
> <a href="https://ml.seasar.org/mailman/listinfo/seasar-dotnet" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-dotnet</a><br>
><br>
_______________________________________________<br>
seasar-dotnet mailing list<br>
<a href="mailto:seasar-dotnet@ml.seasar.org">seasar-dotnet@ml.seasar.org</a><br>
<a href="https://ml.seasar.org/mailman/listinfo/seasar-dotnet" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-dotnet</a><br>
</div></div></blockquote></div><br></div>