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]
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