Re: 1064 errors

2009-04-22 Thread Peter Brawley
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

1064 errors

2009-04-22 Thread Matthew Stuart
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