SQL Syntax Error

[atoy]

Good day,

I'm doing an asp.net web site an i have to update users in the ASPNETDB.

I'm getting an error on the following update query...
Incorrect syntax near the keyword 'INNER'.

Some on can help me please


UPDATE dbo_aspnet_Memb ership INNER JOIN dbo_aspnet_User s
SET [Username] = @UserName, [Email] = @Email
FROM dbo_aspnet_Memb ership INNER JOIN dbo_aspnet_User s
ON dbo_aspnet_Memb ership.UserId = dbo_aspnet_User s.UserId
WHERE [UserId] = @UserId

[deepuv04]

Try this

UPDATE dbo_aspnet_Users 
SET [Username] = @UserName, [email] = @Email 
FROM dbo_aspnet_Membership INNER JOIN dbo_aspnet_Users 
ON dbo_aspnet_Membership.UserId = dbo_aspnet_Users.UserId 
WHERE [UserId] = @UserId

[atoy]

Thanks for your reply Deepuv04.

It works great!

Have a nice day.