2012-05-07から1日間の記事一覧
select * from D_CONTRACTleft join D_ORDERon CRNOCR = ODNOCRand ODNOOD = (select max(ODNOOD) from D_ORDER as D_ORDER2 where D_ORDER2.ODNOCR = D_ORDER.ODNOCR ) Joinの条件に対象のキーの最大値を含める
select * from D_CONTRACTleft join D_ORDERon CRNOCR = ODNOCRand ODNOOD = (select max(ODNOOD) from D_ORDER as D_ORDER2 where D_ORDER2.ODNOCR = D_ORDER.ODNOCR ) Joinの条件に対象のキーの最大値を含める