error[E0277]: Cannot select `posts::columns::id` from `users::table`
  --> src/main.rs:30:10
   |
30 |         .select((users::id, users::name, posts::id))
   |          ^^^^^^ the trait `SelectableExpression<users::table>` is not implemented for `posts::columns::id`
   |
   = note: `posts::columns::id` is no valid selection for `users::table`
   = help: the following other types implement trait `SelectableExpression<QS>`:
             `posts::columns::id` implements `SelectableExpression<JoinOn<Join, On>>`
             `posts::columns::id` implements `SelectableExpression<Only<posts::table>>`
             `posts::columns::id` implements `SelectableExpression<SelectStatement<FromClause<From>>>`
             `posts::columns::id` implements `SelectableExpression<Tablesample<posts::table, TSM>>`
             `posts::columns::id` implements `SelectableExpression<posts::table>`
             `posts::columns::id` implements `SelectableExpression<query_source::joins::Join<Left, Right, Inner>>`
             `posts::columns::id` implements `SelectableExpression<query_source::joins::Join<Left, Right, LeftOuter>>`
   = note: required for `(users::columns::id, users::columns::name, posts::columns::id)` to implement `SelectableExpression<users::table>`
   = note: required for `SelectStatement<FromClause<table>, ..., ..., ...>` to implement `SelectDsl<(users::columns::id, users::columns::name, posts::columns::id)>`
   = note: the full name for the type has been written to '/private/tmp/bad-select/target/debug/deps/bad_select-0b5de3d7dcbea2fe.long-type-9650757499063245021.txt'
   = note: consider using `--verbose` to print the full type name to the console

error[E0271]: type mismatch resolving `<table as AppearsInFromClause<table>>::Count == Once`
  --> src/main.rs:30:10
   |
30 |         .select((users::id, users::name, posts::id))
   |          ^^^^^^ expected `Once`, found `Never`
   |
note: required for `posts::columns::id` to implement `AppearsOnTable<users::table>`
  --> src/main.rs:17:9
   |
17 |         id -> Integer,
   |         ^^
   = note: associated types for the current `impl` cannot be restricted in `where` clauses
   = note: 1 redundant requirement hidden
   = note: required for `(users::columns::id, users::columns::name, posts::columns::id)` to implement `AppearsOnTable<users::table>`
   = note: required for `(users::columns::id, users::columns::name, posts::columns::id)` to implement `SelectableExpression<users::table>`
   = note: required for `SelectStatement<FromClause<table>, ..., ..., ...>` to implement `SelectDsl<(users::columns::id, users::columns::name, posts::columns::id)>`
   = note: the full name for the type has been written to '/private/tmp/bad-select/target/debug/deps/bad_select-0b5de3d7dcbea2fe.long-type-9650757499063245021.txt'
   = note: consider using `--verbose` to print the full type name to the console

error[E0277]: Cannot select `posts::columns::id` from `users::table`
    --> src/main.rs:31:15
     |
31   |         .load(conn)
     |          ---- ^^^^ the trait `SelectableExpression<users::table>` is not implemented for `posts::columns::id`
     |          |
     |          required by a bound introduced by this call
     |
     = note: `posts::columns::id` is no valid selection for `users::table`
     = help: the following other types implement trait `SelectableExpression<QS>`:
               `posts::columns::id` implements `SelectableExpression<JoinOn<Join, On>>`
               `posts::columns::id` implements `SelectableExpression<Only<posts::table>>`
               `posts::columns::id` implements `SelectableExpression<SelectStatement<FromClause<From>>>`
               `posts::columns::id` implements `SelectableExpression<Tablesample<posts::table, TSM>>`
               `posts::columns::id` implements `SelectableExpression<posts::table>`
               `posts::columns::id` implements `SelectableExpression<query_source::joins::Join<Left, Right, Inner>>`
               `posts::columns::id` implements `SelectableExpression<query_source::joins::Join<Left, Right, LeftOuter>>`
     = note: required for `(users::columns::id, users::columns::name, posts::columns::id)` to implement `SelectableExpression<users::table>`
     = note: required for `SelectClause<(id, name, id)>` to implement `diesel::query_builder::select_clause::SelectClauseExpression<FromClause<users::table>>`
     = note: required for `SelectStatement<FromClause<table>, ..., ..., ...>` to implement `Query`
     = note: required for `SelectStatement<FromClause<table>, ..., ..., ...>` to implement `LoadQuery<'_, _, _>`
note: required by a bound in `diesel::RunQueryDsl::load`
    --> /Users/will/.cargo/registry/src/index.crates.io-1949cf8c6b5b557f/diesel-2.2.10/src/query_dsl/mod.rs:1542:15
     |
1540 |     fn load<'query, U>(self, conn: &mut Conn) -> QueryResult<Vec<U>>
     |        ---- required by a bound in this associated function
1541 |     where
1542 |         Self: LoadQuery<'query, Conn, U>,
     |               ^^^^^^^^^^^^^^^^^^^^^^^^^^ required by this bound in `RunQueryDsl::load`
     = note: the full name for the type has been written to '/private/tmp/bad-select/target/debug/deps/bad_select-0b5de3d7dcbea2fe.long-type-9014210247471724487.txt'
     = note: consider using `--verbose` to print the full type name to the console

error[E0271]: type mismatch resolving `<table as AppearsInFromClause<table>>::Count == Once`
    --> src/main.rs:31:15
     |
31   |         .load(conn)
     |          ---- ^^^^ expected `Once`, found `Never`
     |          |
     |          required by a bound introduced by this call
     |
note: required for `posts::columns::id` to implement `AppearsOnTable<users::table>`
    --> src/main.rs:17:9
     |
17   |         id -> Integer,
     |         ^^
     = note: associated types for the current `impl` cannot be restricted in `where` clauses
     = note: 1 redundant requirement hidden
     = note: required for `(users::columns::id, users::columns::name, posts::columns::id)` to implement `AppearsOnTable<users::table>`
     = note: required for `(users::columns::id, users::columns::name, posts::columns::id)` to implement `SelectableExpression<users::table>`
     = note: required for `SelectClause<(id, name, id)>` to implement `diesel::query_builder::select_clause::SelectClauseExpression<FromClause<users::table>>`
     = note: required for `SelectStatement<FromClause<table>, ..., ..., ...>` to implement `Query`
     = note: required for `SelectStatement<FromClause<table>, ..., ..., ...>` to implement `LoadQuery<'_, _, _>`
note: required by a bound in `diesel::RunQueryDsl::load`
    --> /Users/will/.cargo/registry/src/index.crates.io-1949cf8c6b5b557f/diesel-2.2.10/src/query_dsl/mod.rs:1542:15
     |
1540 |     fn load<'query, U>(self, conn: &mut Conn) -> QueryResult<Vec<U>>
     |        ---- required by a bound in this associated function
1541 |     where
1542 |         Self: LoadQuery<'query, Conn, U>,
     |               ^^^^^^^^^^^^^^^^^^^^^^^^^^ required by this bound in `RunQueryDsl::load`
     = note: the full name for the type has been written to '/private/tmp/bad-select/target/debug/deps/bad_select-0b5de3d7dcbea2fe.long-type-9014210247471724487.txt'
     = note: consider using `--verbose` to print the full type name to the console

Some errors have detailed explanations: E0271, E0277.
For more information about an error, try `rustc --explain E0271`.
error: could not compile `bad-select` (bin "bad-select") due to 4 previous errors