Product Table ----------------- ProductID ProductName Order Table --------------- OrderNo ProductID Qty How would you select from both tables but the Order table must always return everything

32.

Product Table
-----------------
ProductID
ProductName

Order Table
---------------
OrderNo
ProductID
Qty

How would you select from both tables but the Order table must always return everything

SELECT dbo.[Order].*, dbo.Product.*
FROM dbo.[Order] RIGHT OUTER JOIN
dbo.Product ON dbo.[Order].ProductID = dbo.Product.ProductID

SELECT dbo.[Order].*, dbo.Product.*
FROM dbo.[Order] INNER JOIN
dbo.Product ON dbo.[Order].ProductID = dbo.Product.ProductID

SELECT dbo.[Order].*, dbo.Product.*
FROM dbo.[Order] LEFT OUTER JOIN
dbo.Product ON dbo.[Order].ProductID = dbo.Product.ProductID

SELECT dbo.[Order].*, dbo.Product.*
FROM dbo.[Order] FULL OUTER JOIN
dbo.Product ON dbo.[Order].ProductID = dbo.Product.ProductID

No description found.