Hello fellow programmers



I get an error message parsing this stored procedure:



CREATE PROCEDURE dbo.up_parmupd_UserT_CCT

   (@Firstname VarChar(50),

    @Lastname VarChar(50),

    @EmailAddress VarChar(50),

    @Username VarChar(30),

    @Password VarChar(10),

    @CCType VarChar(20),

    @ExpMonth Int,

    @ExpYear Int,

    @CCNumber Uniqueidentifier,

    @Donations Money) AS

UPDATE User_T

JOIN Creditcard_T ON

Creditcard_T.Creditcard_ID = User_T.Creditcard_ID

SET First_Name_VC = @Firstname, Last_Name_VC = @Lastname,

Email_Address_VC = @EmailAddress, User_Name_VC = @Username,

Password_VC = @Password, Creditcard_Type_VC = @CCType,

Creditcard_Exp_Month_IN = ExpMonth,

Creditcard_Exp_Year_IN = @ExpYear,

Creditcard_Number_UI = @CCNumber,

Donations_MN = @Donations

WHERE User_Name_VC = @Username AND

Password_VC = @Password



I get the error message:



Server: Msg 156, Level 15, State 1, Procedure up_parmupd_UserT_CCT, Line 13

Incorrect syntax near the keyword 'JOIN'.



What's the problem?



Regards Christian Dygaard