An Urgent help for UPDATE with INNER join

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

SQL Server 2000 Forums

Transact-SQL (2000)

An Urgent help for UPDATE with INNER join

Author

Topic

prince123
Starting Member

5 Posts

Posted - 2005-09-13 : 18:05:16

I would like to ask a similar thing. I am querying MS SQL Server 2000 with the following query:

UPDATE (TblX INNER JOIN TblY
ON TblX.A = TblY.B)
INNER JOIN TblZ
ON (TblX.C = TblZ.C) AND (TblY.D = TblZ.D)
SET TblX.F = 1, TblX.E = GetDate()
WHERE ((TblX.F)<1)
AND TblX.C = 14
AND TblZ.D = 'US'

It raises the following error each time:

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '('.

Any workaround will be highly appreciated. Thank you!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-09-13 : 18:14:24

UPDATE x
FROM TblX x
INNER JOIN TblY y
ON x.A = y.B
INNER JOIN TblZ z
ON x.C = z.C AND y.D = z.D
WHERE x.F < 1 AND x.C = 14 AND z.D = 'US'

Tara

prince123
Starting Member

5 Posts

Posted - 2005-09-13 : 18:48:49

Thanks Tara for your quick help but it started raising this new error:

Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'FROM'.

Should we not place a SET in your solution anywhere. Please guide. Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-09-13 : 18:55:13

Oops, forgot to include it. Here you go:

UPDATE x
SET F = 1, E = GETDATE()
FROM TblX x
INNER JOIN TblY y
ON x.A = y.B
INNER JOIN TblZ z
ON x.C = z.C AND y.D = z.D
WHERE x.F < 1 AND x.C = 14 AND z.D = 'US'

Tara

prince123
Starting Member

5 Posts

Posted - 2005-09-14 : 12:37:10

Thanks Tara for your nice help. It worked fine :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources