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

Tolal:0 Click:

Show All Comments

Did not find what you were looking for leave your name and message. We will revert within 24 hours
Name:
eMail:
Comment / Feedback: