In Oracle, INNER JOIN
is used to fetch records from more than one table that have matching field or column values in both tables. It appears immediately after the FROM clause.
To fetch records from more than one tables that have matching field or column values in both tables, use the following syntax:
Parameters:
tablename1 & tablename2: The table name from which you want to fetch records.
col1: The column or field name that will be return.
INNER JOIN
, both have matching column values in tables :
Note:
In the above example, we are fetching "accountName" fields value from "tblbankdemataccountcharges" table and "banks" fields value from "tblbankheadquartersandaddress" table, both have matching column values in tables.