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?
Explanation:
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.
Explanation:
The formula filters for numbers strictly greater than 10. Out of the given values, 15 and 20 satisfy the condition, so the function returns 2.
Explanation:
TODAY() returns the current date (without time). NOW() returns date and time. DATE creates a date from components. CURRENTDATE is not a function.
No comments yet. Be the first to start the discussion!