java中outer和inner_Left，Right，Outer和Inner Joins有什么区别？

让它更明显可能会有所帮助 . 一个例子：

表格1：

ID_STUDENT STUDENT_NAME

1 Raony

2 Diogo

3 Eduardo

4 Luiz

表2：

ID_STUDENT LOCKER

3 l1

4 l2

5 l3

我做的是：

-Inner join of Table 1 and Table 2:

- Inner join returns both tables merged only when the key

(ID_STUDENT) exists in both tables

ID_STUDENT STUDENT_NAME LOCKER

3 Eduardo l1

4 Luiz l2

-Left join of Table 1 and Table 2:

- Left join merges both tables with all records form table 1, in

other words, there might be non-populated fields from table 2

ID_ESTUDANTE NOME_ESTUDANTE LOCKER

1 Raony -

2 Diogo -

3 Eduardo l1

4 Luiz l2

-Right join of table 1 and table 2:

- Right join merges both tables with all records from table 2, in

other words, there might be non-populated fields from table 1

ID_STUDENT STUDENT_NAME LOCKER

3 Eduardo l1

4 Luiz l2

5 - l3

-Outter join of table 1 and table 2:

- Returns all records from both tables, in other words, there

might be non-populated fields either from table 1 or 2.

ID_STUDENT STUDENT_NAME LOCKER

1 Raony -

2 Diogo -

3 Eduardo l1

4 Luiz l2

5 - l3