CREATE TABLE A
(
a INT
)Table created.
CREATE TABLE B
(
b INT
)Table created.
Insert into A (a) Values (1)1 row(s) inserted.
Insert into A (a) Values (2)1 row(s) inserted.
Insert into A (a) Values (3)1 row(s) inserted.
Insert into A (a) Values (4)1 row(s) inserted.
Insert into B (b) Values (3)1 row(s) inserted.
Insert into B (b) Values (4)1 row(s) inserted.
Insert into B (b) Values (5)1 row(s) inserted.
Insert into B (b) Values (6)1 row(s) inserted.
COMMITStatement processed.
SELECT * FROM A| A | 1 | 2 | 3 | 4 |
|---|
SELECT * FROM B| B | 3 | 4 | 5 | 6 |
|---|
select * from A INNER JOIN B on A.a = B.b| A | B | 3 | 3 | 4 | 4 |
|---|
select A.*, B.* from A, B where A.a = B.b| A | B | 3 | 3 | 4 | 4 |
|---|
select * from A LEFT OUTER JOIN B on A.a = B.b| A | B | 3 | 3 | 4 | 4 | 1 | - | 2 | - |
|---|
select A.*,B.* from A,B where A.a = B.b(+)| A | B | 3 | 3 | 4 | 4 | 1 | - | 2 | - |
|---|
select * from A RIGHT OUTER JOIN B on A.a = B.b| A | B | 3 | 3 | 4 | 4 | - | 6 | - | 5 |
|---|
select A.*,B.* from A,B where A.a(+) = B.b| A | B | 3 | 3 | 4 | 4 | - | 6 | - | 5 |
|---|
select * from A FULL OUTER JOIN B on A.a = B.b| A | B | 3 | 3 | 4 | 4 | - | 5 | - | 6 | 1 | - | 2 | - |
|---|