How To Join Two Tables in a Single Query
Q
How To Join Two Tables in a Single Query? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: 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.
2007-04-20, 5502👍, 0💬
Related Topics:
