336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
- In SQL: 1999, the join of two ables returning only matched rows is called inner join.
- A join between two tables that returns the results of the inner join as well as the unmatched rows from the left(or right) tables is called a left(or right) outer join.
- A join between two tables that returns the results of an inner join as well as the results of a left and right join is a full outer join.
'Oracle' 카테고리의 다른 글
| Cartesian product. (0) | 2006.09.01 |
|---|---|
| INNER join vs OUTER joins (0) | 2006.09.01 |
| SUM + DECODE + TO_CHAR (0) | 2006.08.31 |
| SUM + DECODE + TO_CHAR (0) | 2006.08.31 |
| Restricting Group Results (0) | 2006.08.31 |