The PostgreSQL JDBC Interface | ||
---|---|---|
<<< Previous | JDBC escapes | 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)} "); |
<<< Previous | Home | Next >>> |
JDBC escapes | Up | Date-time escapes |