联合查询

union/union all 示例 1.4.8+

class MpJoinTest {
    @Resource
    private UserMapper userMapper;

    @Test
    void union() {
        MPJLambdaWrapper<User> w = JoinWrappers.lambda(User.class)
                .selectAll(User.class)
                .union(User.class, union -> union
                        .selectAll(User.class))
                .union(User.class, union -> union
                        .selectAll(User.class));
        //union all 调用unionAll即可 如下
        //.unionAll(User.class, union -> union...);
        w.list();
    }
}

对应log

SELECT t.id,
       t.pid,
       t.`name`,
       t.`json`,
       t.sex,
       t.head_img,
       t.create_time
FROM `user` t
UNION
SELECT t.id,
       t.pid,
       t.`name`,
       t.`json`,
       t.sex,
       t.head_img,
       t.create_time
FROM `user` t
UNION
SELECT t.id,
       t.pid,
       t.`name`,
       t.`json`,
       t.sex,
       t.head_img,
       t.create_time
FROM `user` t