When you using an Inner Join, rows from table that match a common value are the only ones returned.
In SQL server, of we can create a new table by combining rows that have values that match in two or more tables by using an inner join clause.
Logically, this is used to retrieve data from tables that have a common field or appears to have data in both tables.
The diagram below shows the data retrieved using Inner Join in SQL Server which is represented by the part in black.
- Therefore, when you using an Inner Join, rows from table that match a common value are the only ones returned.
Learn more about Inner Join on:
https://brainly.com/question/12851463
