fel syntax — webForum

PercyMedlem sedan mars 2000187 inlägg

31 aug. 2002 17:18#1

hej, får inte denna att fungera, hur skall det se ut? är ngt med mina inner joins som inte är helt bra...

SELECT Article.ArticleName, Article.SurfaceId, Category.CategoryName, Category.CategoryName2, Category.ParentCategoryId, Customer.DeliverySurname, Customer.DeliveryLastname, Customer.DeliveryStreetname, Customer.DeliveryZipcode, Customer.DeliveryCity, Customer.PhoneHome, Customer.PhoneWork, 
Customer.PhoneMobile, Customer.Email, OrderHead.OrderId, OrderHead.OrderNo, OrderHead.OrderDate, OrderHead.OrderStatusId, OrderHead.WayOfDelivery, OrderHead.OurReference, Orderitem.ArticleId, Orderitem.Price, Orderitem.Amount, TaxRate.TaxPercent 
FROM ((Customer INNER JOIN TaxRate ON Article.TaxId = TaxRate.TaxId) INNER JOIN OrderHead ON Customer.CustomerId = OrderHead.CustomerId) INNER JOIN OrderItem ON OrderHead.OrderId = OrderItem.OrderId) INNER JOIN Category INNER JOIN Article ON Category.CategoryId = Article.CategoryId) ON OrderItem.ArticleId = Article.ArticleId WHERE OrderHead.OrderId = " & OrderId & " ORDER BY Category.CategoryName ASC, Article.ArticleName ASC, Article.SurfaceId ASC

den säger:
Line 1: Incorrect syntax near ')'.

tack på förhand!

LarsGMedlem sedan dec. 200012 464 inlägg

31 aug. 2002 17:48#2

SELECT Article.ArticleName, 
       Article.SurfaceId, 
       Category.CategoryName, 
       Category.CategoryName2, 
       Category.ParentCategoryId, 
       Customer.DeliverySurname, 
       Customer.DeliveryLastname, 
       Customer.DeliveryStreetname, 
       Customer.DeliveryZipcode, 
       Customer.DeliveryCity, 
       Customer.PhoneHome, 
       Customer.PhoneWork, 
       Customer.PhoneMobile, 
       Customer.Email, 
       OrderHead.OrderId, 
       OrderHead.OrderNo, 
       OrderHead.OrderDate, 
       OrderHead.OrderStatusId, 
       OrderHead.WayOfDelivery, 
       OrderHead.OurReference, 
       Orderitem.ArticleId, 
       Orderitem.Price, 
       Orderitem.Amount, 
       TaxRate.TaxPercent 
  FROM ((((Customer 
        INNER JOIN OrderHead ON Customer.CustomerId = OrderHead.CustomerId)  
        INNER JOIN Orderitem ON OrderHead.OrderId = OrderItem.OrderId) 
        INNER JOIN Article   ON OrderItem.ArticleId = Article.ArticleId)
        INNER JOIN TaxRate   ON Aricle.TaxId = TaxRate.TaxId) 
        INNER JOIN Category  ON Category.CategoryId = Article.CategoryId 
  WHERE OrderHead.OrderId = " & OrderId & " 
  ORDER BY Category.CategoryName ASC, Article.ArticleName ASC, Article.SurfaceId ASC