Description: The INNER JOIN keyword return rows when there is at least one match in both tables.
An inner join requires each record in the two joined tables to have a matching record. An inner join essentially combines the records from two tables (A and B) based on a given join-predicate. The result of the join can be defined as the outcome of first taking the Cartesian product (or cross-join) of all records in the tables (combining every record in table A with every record in table B) - then return all records which satisfy the join predicate.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 07th, 2009
SELECT column_name(s)FROM table_name1
INNER JOIN table_name2
-- for example:SELECT Person.LastName, Person.FirstName, Sales.OrderNo
INNER JOIN Sales
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.