---
title: "Update samt Join"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/111680-update-samt-join"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Quazzo"
published: "2004-09-16T09:00:09.000Z"
updated: "2004-09-16T10:27:09.000Z"
replies: 1
views: 225
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/111680-update-samt-join"
---

# Update samt Join

## #1 — Quazzo, 2004-09-16T09:00Z

Hej!
Har problem när jag ska uppdatera min SQL-server databas.

\------------------------------------
Update Member right join History 
ON Member.MemberNr = History.MemberNr 
SET Member.Member=0
where and Paid=0 and member=1 order by member.LastName, member.Firstname
\-----------------------------------

Ger följande fel:
\------------------------------------------------------
Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'join'.
\------------------------------------------------------

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

## #2 — LarsG, 2004-09-16T10:27Z

```
Update Member
SET Member.Member=0
where Paid=0 
and member=1 
and MemberNr in (select MemberNr from history)
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/111680-update-samt-join