lovefield left outer join

   db
    .select()
    .from(tableA)
    .leftOuterJoin(tableB, lf.op.and(tableA.id.eq(tableB.id), tableA.somefield.eq(tableB.somefield)))
    .exec();