Asked by Karen Gonzales on Jun 20, 2024
Verified
Which of the following join types can you create by double-clicking a join line in Query Design View? Select all the options that apply.
A) right outer
B) left outer
C) inner
D) upper
Right Outer
Type of join in SQL that returns all records from the right table and the matched records from the left table.
Left Outer
A type of SQL JOIN that returns all records from the left table and matched records from the right table, filling with NULLs if there is no match.
- Comprehend the use of joins in retrieving relationships between specific records through queries.
Verified Answer
EH
Elaine HinojosaJun 22, 2024
Final Answer :
A,B,C
Explanation :
Double-clicking a join line in Query Design View allows you to choose the type of join you want to create. The options available are right outer join, left outer join, and inner join. "Upper" is not a valid join type.
Learning Objectives
- Comprehend the use of joins in retrieving relationships between specific records through queries.