---
title: "fel syntax"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/51826-fel-syntax"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Percy"
published: "2002-08-31T17:18:29.000Z"
updated: "2002-08-31T17:48:15.000Z"
replies: 1
views: 181
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/51826-fel-syntax"
---

# fel syntax

## #1 — Percy, 2002-08-31T17:18Z

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!

Permalänk: https://www.webforum.nu/p/51826

## #2 — LarsG, 2002-08-31T17:48Z

```
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
```

Permalänk: https://www.webforum.nu/p/769505

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/51826-fel-syntax