求助：KSQL有没有左外连接？

liaogen1984

我在KSQL编辑器可以实现两表的连接，但这种连接好像是全连接样的，请问KSQL可以实现左外连接么？
KSQL编辑器生成的连接语句如下：
select RE_A1,RE_A1.VERSION as VERSION,RE_A1.FNAME as FNAME,RE_A1.FCOMPANY as FCOMPANY,RE_A1.FPLACE as FPLACE,RE_A1.SBU as SBU,RE_B2,RE_B2.VERSION as VERSION1,RE_B2.FSTU as FSTU,RE_B2.FFACTORY as FFACTORY,RE_B2.FBIRTH as FBIRTH,RE_B2.SBU as SBU1,(SQL.comparename(RE_A1.FNAME, RE_B2.FSTU)) as CompareName,(SQL.comparecompany(RE_A1.FCOMPANY, RE_B2.FFACTORY)) as CompareCompany,(SQL.compareplace(RE_A1.FPLACE, RE_B2.FBIRTH)) as ComparePlace,(SQL.compareresult(RE_A1.FNAME, RE_B2.FSTU, RE_A1.FCOMPANY, RE_B2.FFACTORY, RE_A1.FPLACE, RE_B2.FBIRTH)) as CompareResult
    from RE_A1 RE_A1
     join RE_B2 RE_B2 on RE_A1 = RE_B2
    where RE_A1.SBU = :p

jishuang

//连接--左连接OPTIONAL JOIN
                String kSqlJoin ="SELECT p1.sCode AS sPCode, p1.sName AS sPName, o1.sCode AS sOCode, o1.sName AS sOName FROM SA_OPPerson p1"
                                        +" OPTIONAL JOIN SA_OPOrg o1 ON p1.sMainOrgID = o1 WHERE o1.sName='起步软件'";