Can I join the same table?

[myyrakle]

The table has a key value that refers to itself, so you want to join the same table.

Is this a function currently available?
If possible, which method should you use?

example

let history_list: Vec<_> = tb_document_history::table // as A
            .inner_join(tb_user::table.on(tb_user::dsl::id.eq(tb_document_history::dsl::writer_id))) // as B
            .left_join(
                tb_document_history::table // as C?
                    .on(tb_document_history::dsl::id.eq(tb_document_history::dsl::rollback_id)
                ),
            )
            .filter(tb_document_history::dsl::document_id.eq(document.id))
            //...

[weiznich]

You would need to provide your own alias extension to the query builder, otherwise this is not supported yet using the built-in dsl. #1611 has some details on possible solutions.

[myyrakle]

Thank you for answer.