I need to create a query that shows all of the products that were shipped via the same method as OrderID 10248.
FROM dbo.Products JOIN
orders on ShipVia = (select distinct ShipVia AS sv from Orders where OrderID = 10248) INNER JOIN
dbo.Orders ON dbo.[Order Details].OrderID = dbo.Orders.OrderID INNER JOIN
dbo.Products ON dbo.[Order Details].ProductID = dbo.Products.ProductID
This is how the columns are related:
-Order Details -Orders -Prodcuts
OrderID OrderID ProductID