---
title: "Proglem med join!"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/149128-proglem-med-join"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "webbSAJTEN"
published: "2006-07-16T18:15:23.000Z"
updated: "2006-07-16T18:20:11.000Z"
replies: 1
views: 217
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/149128-proglem-med-join"
---

# Proglem med join!

## #1 — webbSAJTEN, 2006-07-16T18:15Z

```
SQL = "SELECT C.ID, C.intUserID, C.strFile, C.strDate, C.strSize, C.intVarde, C.orderID, C.strVat, C.strInfo, C.strStatus A.strName, A.ID " _
& "FROM cart C join anv A on C.intUserID = A.ID "_
& "Order by C.ID"
Set RS = Connect.Execute(SQL)
```

Jag får felmess:

```
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '.strName, A.ID FROM cart C join anv A on C.intUserID = A.ID Ord
```

Vad kan vara fel?

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

## #2 — LarsG, 2006-07-16T18:20Z

Fattas ett komma efter C.strStatus

Flyttas från ASP

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/149128-proglem-med-join