In MS Access, which join type in a Query design screen extracts all records from Table A and only those records from Table B that have matching key values? MCQ with Answer and Explanation
In MS Access, which join type in a Query design screen extracts all records from Table A and only those records from Table B that have matching key values?
A. Full Cross Join
B. Left Outer Join
C. Inner Join
D. Right Outer Join
Answer: Option B
Solution (By JKSSB Mock Tests)
A Left Outer Join includes all records from the left table (Table A) and matching rows from the right table (Table B). If no match exists, NULL values appear on the right side.
No comments yet. Be the first to start the discussion!