DATABASE & SQL/PLSQL

Inner Join
Previous Home Next

In inner joining, data from multiple tables is displayed after comparing values present in a common column. Only rows with values satisfying the join condition column are displayed. Rows in both tables that do not satisfy the join condition are not displayed.

SELECT columnm_name
FROM table_name JOIN table_name
ON [table_name.ref_column_name]  join_operator  [table_name.ref_column_name]

Example:

SELECT title, royaltyper, royalty
FROM titleauthor JOIN titles
ON titleauthor.title_id=titles.title_id

Return all title, royaltyper, royalty from table in which these attributes are present

 

output

Previous Home Next