1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
---
layout: default_docs
title: Escape for outer joins
header: Chapter 8. JDBC escapes
resource: media
previoustitle: Chapter 8. JDBC escapes
previous: escapes.html
nexttitle: Date-time escapes
next: 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 :
```java
rs = stmt.executeQuery( "select * from {oj a left outer join b on (a.i=b.i)} ");
```
|
