Ways to Join Two Tables in a Single Query in Oracle
Q
How To Join Two Tables in a Single Query in Oracle?
✍: FYIcenter.com
A
Two tables can be joined together in a query in 4 ways:
- Inner Join: Returns only rows from both tables that satisfy the join condition.
- Left Outer Join: Returns rows from both tables that satisfy the join condition, and the rest of rows from the first (left) table.
- Right Outer Join: Returns rows from both tables that satisfy the join condition, and the rest of rows from the second (right) table.
- Full Outer Join: Returns rows from both tables that satisfy the join condition, the rest of rows from the first (left) table, and the rest of rows from the second (right) table.
2016-10-17, 381👍, 0💬
Related Topics:
