Microsoft 77-605 Free Exam Question 2
Andrew works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer that has Microsoft Office 2007 installed. The computer has a database named Sales. The database has two tables named Order and OrderDetails. Both the tables are joined by a column named OrderID. Andrew wants to retrieve data from both the tables such that all data is to be retrieved from the Order table and only matching rows from the OrderDetails table. If the data does not match, NULL should be inserted in the OrderDetails table. Which of the following queries will he use to accomplish the task?
A. SELECT * FROM Order o CROSS JOIN OrderDetails od ON o.OrderID=od.OrderID
B. SELECT * FROM Order o LEFT OUTER JOIN OrderDetails od ON o.OrderID=od.OrderID
C. SELECT * FROM Order o RIGHT OUTER JOIN OrderDetails od ON o.OrderID=od.OrderID
D. SELECT * FROM Order o FULL OUTER JOIN OrderDetails od ON o.OrderID=od.OrderID