ar jn = new JoinSqlBuilder<UserEx, User>();
+ jn = jn.Join<User, UserData>(x => x.UserDataId, x => x.Id, x => new { x.Name, x.Id }, x => new { x.UserDataValue })
+ .LeftJoin<User, UserService>(x => x.UserServiceId, x => x.Id, null, x => new { x.ServiceName })
+ .OrderByDescending<User>(x=>x.Name)
+ .OrderBy<User>(x=>x.Id)
+ .Select<User>(x=>x.Id)
+ .Where<User>(x=> x.Id == 0);