This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
You must return a list of all sales employees that have taken sales orders. Employees who have not taken sales orders should not be included in the results. Which type of join is required?
INNER
LEFT OUTER
FULL OUTER
Which type of JOIN operation does not require an ON clause?
LEFT OUTER JOIN
CROSS JOIN
FULL JOIN
You write the following query: SELECT p.Name, c.Name FROM Store.Product AS p CROSS JOIN Store.Category AS c; What does the query return?
Only data rows where the product name is the same as the category name
Only rows where the product name is not the same as the category name
Every combination of product and category name
You must answer all questions before checking your work.
Was this page helpful?