update and inner join problem - SQL Server Forums

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

Other Forums

Other Topics

update and inner join problem

Author

Topic

g_r_a_robinson
Starting Member

45 Posts

Posted - 2004-08-23 : 20:19:47

Im trying simply to update a row that meets the conditions of my inner joins, here it is:

update subscriptions
set plan_id = 007
from subscriptions s, dial_in_services dis, usernames u
where s.subscription_id = dis.subscription_id
and u.username_id = dis.username_id
and u.username = 'ycs_testme'

this won't work. I'm being told 'sql command not properley ended'.

All of the examples I've searched for follow this same format. Yet I've tried everything and still no dice.

By the way this is oracle 8i.

Thanks

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-08-23 : 21:41:51

quote:

By the way this is oracle 8i

Hmm, in a Transact SQL forum. You might be better asking on an Oracle site, but I'll move it to the other topics forum.

Damian

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2004-08-24 : 04:01:29

this is a long shot but will this work?

update s
set s.plan_id = 007
from subscriptions s, dial_in_services dis, usernames u
where s.subscription_id = dis.subscription_id
and u.username_id = dis.username_id
and u.username = 'ycs_testme'

Go with the flow & have fun! Else fight the flow :)

mr_mist
Grunnio

1870 Posts

Posted - 2004-08-24 : 05:25:12

Do you need a semi-colon at the end?

[/stab-in-the-dark]

-------
Moo. :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources