Matthew,
>CREATE PROCEDURE 'x'.'CrossSelling' ()
>BEGIN
>SELECT TOP 5 OrderDetails.ProductID, OrderDetails.ProductName,
Count(OrderDetails.ProductID) AS CountOfProductID
>FROM OrderDetails
>WHERE (((OrderDetails.OrderID) In (select OrderID from OrderDetails
where ProductID=[pid])))
>GROUP
Hi, I have several procedures that I have taken from an old Microsoft
database, and I have tired to use them in a MySQL 5.1.32 database, but
I am getting errors when trying to input them. There are three in
total that I am struggling with and would appreciate some guidance...
This is a cros