Navigation : The PostgreSQL JDBC Interface > Escape for outer joins Escape for outer joins Prev Next You can specify outer joins using the following syntax: {oj table (LEFT|RIGHT|FULL) OUTER JOIN (table | outer-join) ON search-condition } For example : rs = stmt.executeQuery( "select * from {oj a left outer join b on (a.i=b.i)} "); Prev Home Next Chapter 8. JDBC escapes Date-time escapes