Update Member
SET Member.Member=0
where Paid=0
and member=1
and MemberNr in (select MemberNr from history)
Trådstart#1
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'.
------------------------------------------------------