dao的func方法怎么实现两个一对一的表关联查询 sum副表的字段啊

dao.func2(OutStock.class,"sum","cktaxe", Cnd.where("yxbz","=","1").and("status","=","0")
        .and("shrq",">=", DateUtil.getQueryTimeByStart(startTime)).and("shrq","<=",DateUtil.getQueryTimeByEnd(endTime)));

cktaxe这个字段是在另外一个表上面，查询条件都是在主表上，就是outstock对应的表

wendal

1楼•2531天前

有 new Static这种大招

cnd.where(...).and(...).and(new Static("xxx in (select xxx from yyy where xxx ... xxx)"));

请先登陆