id, name_a

id, name_b

id_a, id_b

Specification<TableA> specification = (root, query, cb) -> {
        CriteriaQuery<TableAb> abQuery = cb.createQuery(TableAb.class);
        CriteriaQuery<TableB> bQuery = cb.createQuery(TableB.class);

        Root<TableAb> abRoot = abQuery.from(TableAb.class);
        Join<TableAb, TableA> aJoin = abRoot.join("tableA");
        Join<TableAb, TableB> bJoin = abRoot.join("tableB");

        //combine joins

        query.orderBy(cb.asc(/* Expression to order by */));
        return cb.conjunction();
    };