Home » RDBMS Server » Server Administration » Update Query
Update Query [message #372466] Wed, 14 February 2001 07:25 Go to next message
Ron Bowers
Messages: 2
Registered: February 2001
Junior Member
How do I create an update query using an inner join without having to include a subquery in my command? Thank You.

Report message to a moderator

Re: Update Query [message #372467 is a reply to message #372466] Wed, 14 February 2001 07:28 Go to previous messageGo to next message
me
Messages: 66
Registered: August 2000
Member
update table_name
set update_column = update_value
where where_column = where_value

Report message to a moderator

Re: Update Query [message #372468 is a reply to message #372466] Wed, 14 February 2001 07:32 Go to previous messageGo to next message
me
Messages: 66
Registered: August 2000
Member
update table_name
set update_column = update_value
where where_column = where_value

Report message to a moderator

Re: Update Query [message #372469 is a reply to message #372467] Wed, 14 February 2001 07:59 Go to previous messageGo to next message
Ron Bowers
Messages: 2
Registered: February 2001
Junior Member
Thank you for your reply. You gave me an example of an ordinary update query. What I need is and example of an update query joining two tables together without resorting to using a subquery in my sql. Thank You.

Report message to a moderator

Re: Update Query [message #372477 is a reply to message #372469] Wed, 14 February 2001 12:19 Go to previous message
DWu
Messages: 3
Registered: February 2001
Junior Member
update table_name1 T1 inner join table_name2 T2 on T1.join_col = T2.join_col
set update_column = update_value
where where_column = where_value

Report message to a moderator

Previous Topic: Database Links
Next Topic: unions and intersection
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 01:23:39 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.