help with inner join in update

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

help with inner join in update

Author

Topic

Burk
Starting Member

2 Posts

Posted - 2007-08-29 : 22:21:30

Here is my update statements which doesn't work, can you show me an example.

UPDATE zurnacik_user SET zurnacik_user.usergroupid=15
INNER JOIN zurnacik_userfield
ON zurnacik_user.userid = zurnacik_userfield.userid
WHERE zurnacik_userfield.field5 = "Kadýn"
AND zurnacik_user.usergroupid = 2

=================

ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE zurnacik_userfield.field5 = "Kadýn"
AND zurnacik_user.usergroupid = 2
SE' at line 4

=====

I from Turkey, Thank You...

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-08-29 : 22:26:34

ERROR : You have posted a MySQL question on MS SQL Server Forum. Please post at http://forum.mysql.com/

Anyway, this is the ANSI syntax on UPDATE

UPDATE 	zurnacik_user 
SET 	zurnacik_user.usergroupid = 15
FROM 	zurnacik_user 
INNER JOIN zurnacik_userfield
ON 	zurnacik_user.userid = zurnacik_userfield.userid
WHERE 	zurnacik_userfield.field5 = "Kadýn"
AND 	zurnacik_user.usergroupid = 2

KH
[spoiler]Time is always against us[/spoiler]

Burk
Starting Member

2 Posts

Posted - 2007-08-29 : 22:35:48

hmm ok, sorry.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources