Update samt Join

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'.
------------------------------------------------------

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