String query =
 Builder.select().table("MyTable")
                 .fields("F1","F2","F3")
                 .leftJoin("OtherTable","F1)
                 .where("F2",equals,"XPTO")

SELECT F1, F2, F3 from MyTable left join OtherTable on MyTable.F1 = OtherTable.F1 where F2 = "XPTO"