What is oracle Join?
A join is a query that combines rows of two or more tables or views. To perform a JOIN, a join condition must be specified in WHERE clause. The result will be returned for those rows from both tables for which the join condition was met.
Example:Joining results of employee and salary table:
SELECT employee.LastName, employee.FirstName, salary.amount
FROM employee
INNER JOIN salary
ON employee.P_Id=salary.P_Id
ORDER BY employee.LastName
