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.

 

⇒Understanding SQL SELECT Query Statements in Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 290👍, 0💬

General MySQL Oracle SQL Server