# notDefaultSelectAll() 不默认查询主表全部的字段
WARNING
因为默认是查询主表所有查询字段,如果不需要查询主表全部字段就调用该方法notDefaultSelectAll()
JoinLambdaWrapper<Users> wrapper = new JoinLambdaWrapper<>(new Users().setUserName("name啊")
.setUserId(1L));
wrapper.notDefaultSelectAll()
.leftJoin(UsersAge.class,UsersAge::getId,Users::getAgeId)
.eq(UserAge::getAgeName,"95")
.select(UserAge::getAgeName).end();
// 执行查询
usersService.joinList(wrapper,UsersVo.class);
// 执行SQL
select
users_age.age_name
from users users
left join users_age users_age on users_age.id = users.age_id
where
users.user_id = 1
and users.user_name = 'name啊'
and users_age.age_name = '95'