openGauss-connector-jdbc/docs/documentation/94/outer-joins-escape.md

layout, title, header, resource, previoustitle, previous, nexttitle, next

layout	title	header	resource	previoustitle	previous	nexttitle	next
default_docs	Escape for outer joins	Chapter 8. JDBC escapes	media	Chapter 8. JDBC escapes	escapes.html	Date-time escapes	escapes-datetime.html

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)} ");