Answer to Question #76508 in Databases | SQL | Oracle | MS Access for J

Question

What would the following query include?

SELECT Customer_T.CustomerID,CustomerName, OrderID

FROM Customer_T RIGHT OUTER JOIN Order_T

ON Customer_T.CustomerID = Order_T.CustomerID


only rows that match both Customer_T and Order_T Tables


only rows that do not match both Customer_T and Order_T Tables


all rows of the Order_T Table regardless of matches with the Customer_T Table


all rows of the Customer_T Table regardless of matches with the Order_T Table

Answer 1

- all rows of the Order_T Table regardless of matches with the Customer_T Table