[Solved] What does an inner join display?

McqMate

Q.	What does an inner join display?
A.	Records from the second recordset and only records from the first recordset where the common fields are equal
B.	Records from the first recordset and only records from the second recordset where the common fields are equal
C.	Records that have the same value in the common field
D.	Records from the first recordset only
Answer» C. Records that have the same value in the common field

2k

0

Do you find this helpful?

14

View all MCQs in

Microsoft Access (MS Access)

Discussion

No comments yet

Related MCQs

You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
A global join will be created automatically when using tables in a(n) _____.
Which of the following is the default join between two recordsets?
In a query\'s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?
You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?
You can display a database object in design view by
How can you display the relationship in a database?
How can you display Pivot Table report summary data in a currency format?
How can you display sales grouped by country, region, and salesperson, all at the same time?
To display sales grouped by country, region, and salesperson, all at the same time