联合查询
union/union all 示例 1.4.8+
class MpJoinTest {
@Resource
private UserMapper userMapper;
@Test
void union() {
MPJLambdaWrapper<UserDO> w = JoinWrappers.lambda(UserDO.class)
.selectAll(UserDO.class)
.union(AddressDO.class, union -> union
.selectAll(UserDO.class))
.union(AddressDO.class, union -> union
.selectAll(UserDO.class));
//union all 调用unionAll即可 如下
//.unionAll(AddressDO.class, union -> union...);
w.list();
}
}
对应log
SELECT t.id,
t.pid,
t.`name`,
t.`json`,
t.sex,
t.head_img,
t.create_time,
t.address_id,
t.address_id2,
t.create_by,
t.update_by
FROM `user` t
UNION
SELECT t.id,
t.pid,
t.`name`,
t.`json`,
t.sex,
t.head_img,
t.create_time,
t.address_id,
t.address_id2,
t.create_by,
t.update_by
FROM `user` t
UNION
SELECT t.id,
t.pid,
t.`name`,
t.`json`,
t.sex,
t.head_img,
t.create_time,
t.address_id,
t.address_id2,
t.create_by,
t.update_by
FROM `user` t