title: HANA Left Outer Join syntax
body: <p>I am trying to build a query in HANA with a left outer join. I am using a (+) sign in the where clause. I do that often in Oracle; but in HANA it is returning a syntax error. Does HANA supports this syntax?</p>
  
  <pre><code>select * 
  FROM
     "_SYS_BIC"."FinancialReporting.ReportingViews.Tech_Analytics/CV_LOA_FINANCIAL_DETAIL_GRA" F1,
     "_SYS_BIC"."FinancialReporting.MasterData/CV_D_ACCOUNT_GRA" F2,
     "_SYS_BIC"."FinancialReporting.MasterData/CV_D_COMPANY_GRA" F3,
     "_SYS_BIC"."FinancialReporting.MasterData/CV_D_COSTCENTER_GRA" F4,
     "_SYS_BIC"."FinancialReporting.ReportingViews/CV_LOA_MEASURES_LEVELS_TA_GRA" F5,
     "_SYS_BIC"."FinancialReporting.MasterData/CV_D_VENDOR_GRA" F6
  WHERE
     (F1."acct_nmbr" = F2."acct_nmbr")
     AND (F1."company_cd" = F3."company_cd")
     AND (F1."cost_center_cd" = F4."cost_center_cd")
     AND (F1."acct_nmbr" = F5."acct_nmbr")
     AND F1."vendor_cd" = F6."vendor_cd"(+)
     AND (F1."acctg_dt" &gt;= '2016-01-01'
     AND F1."acctg_dt" &lt;= '2016-02-01'))
  </code></pre>