MYSQL Query errors

wxdqz

New Member
I am trying to put together a fairly complicated QUesry in MySQL. For some reasons, the web server gives me errors. Here is the Query:

sqlquery = "SELECT DISTINCTROW Order_Details.OrderID, Customers.CompanyName, Customers.ContactFirstName, Customers.ContactLastName, Customers.BillingAddress, Customers.City, Customers.StateOrProvince, Customers.PostalCode, Customers.Country, Customers.EmailAddress, Payments.CardType, Payments.CreditCardNumber, Payments.CreditCardExpDate, Orders.ShipContactFirstName, Orders.ShipContactLastName, Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipStateOrProvince, Orders.ShipPostalCode, Orders.ShipCountry, Orders.ShipPhoneNumber, Order_Details.ProductID, Order_Details.Quantity, Order_Details.UnitPrice, Products.ProductName, Orders.FreightCharge, Customers.PhoneNumber, Customers.City, Payments.AuthCode, Payments.Approved FROM (Products INNER JOIN ((Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID) INNER JOIN Order_Details ON Orders.OrderID = Order_Details.OrderID) ON Products.ProductID = Order_Details.ProductID) INNER JOIN Payments ON Orders.OrderID = Payments.OrderID ORDER BY Order_Details.OrderID DESC"


Any thoughts as to why it pukes?!?

Thanks,

ROberto
 
Back
Top