Question

when creating a sql query, which join clause returns all matching records in two or more database tables?

Answer 1

Inner Join

Step-by-step explanation:

Clause in SQL Server creates a new table (not physical) by combining rows that have matching values in two or more tables. This join is based on a logical relationship (or a common field) between the tables and is used to retrieve data that appears in both tables.