Return to “Everything & Anything”


Re: CTRL - V


Code: Select all

SELECT Orders.OrderID, OrderDetails.ProductID, Products.ProductName, Categories.CategoryName, Suppliers.SupplierName
FROM (((Orders
INNER JOIN OrderDetails ON Orders.OrderID = OrderDetails.OrderID)
inner join Products on OrderDetails.ProductID = Products.ProductID)
inner join Categories on Products.CategoryID = Categories.CategoryID
inner join Suppliers on Products.SupplierID = Suppliers.SupplierID);
I had some fun with the Northwind DB. WHy not inner the thing into the inner into the thing into the inner into... :D
Automation engineer, lateral thinker, soldier, addicted to music, books and gaming.
Nothing to see here
Flatfingers wrote: 23.01.2017: "Show me the smoldering corpse of Perfectionist Josh"

Online Now

Users browsing this forum: No registered users and 1 guest