Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 28 of 134
Free Preview · 134 of 444 · questions 1–134 of 444 are free. Sign up free to sync your progress across devices.
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
* Answer: A. Merge queries * Explanation: Merge queries: Combines two tables based on a matching column (in this case, Order ID) and brings in columns from both tables into a single query. This is what you need because the tables are related by Order ID and you want unique columns from each. * Other options: - Append queries: Stacks tables on top of each other (adds rows), which is used when tables have the same structure. Not suitable here because you want to join related data, not stack it. - Combine files: Used for combining multiple files from a folder, not applicable here since both tables are already in the same database.
A is correct , using Order ID column.
Merging the two using the common OrderID Column is a better option