join

Appends a JOIN statement to a query

// … FROM book JOIN author ON author.id = author_id …
Query q = table("book").qb.join(
    table("author"),
    "id",
    "author_id"
);
// or:
Query q = table("book").qb.join(
    column(table("author"), "id"),
    "author_id"
);

enum book = table("book");
enum author = table("author");
Query q = book.qb.join(
    column(author, "id"),
    column(book, "author_id")
);
// --> … FROM book JOIN author ON author.id = book.author_id …