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
 SQL Server Development (2000)
 Make an update query problem

Author  Topic 

mr_bad_guy
Starting Member

7 Posts

Posted - 2008-08-06 : 09:24:58
I want to make a query to update an existing table but dont know howto.

I will write down what the situation is.

Table One
- ID
- Column 1
- Column 2

Table Two
- ID
- Column 1
- Column 2

What I want to do is the following.

Table One the column 2 is empty no data this I want to fill with the data of Table Two, column 2
The ID of table one is coresponding with Column 1 of table two.

Can someone help??

cardgunner

326 Posts

Posted - 2008-08-06 : 09:39:36
Here is a tutorial site that will show you how to do it plus more

http://www.w3schools.com/sql/default.asp
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm



CardGunner
Go to Top of Page

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-08-06 : 09:40:34
dup...
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=108223

Em
Go to Top of Page

mr_bad_guy
Starting Member

7 Posts

Posted - 2008-08-06 : 09:42:46
I have seen this website's but these aren't that clear to me.. maybe someone can help in this forum
Go to Top of Page

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2008-08-06 : 14:47:23
Elancaster is trying to point you to your post where they are giving you actual query examples to do what they think you need. What's not clear? Copy the query and look for key words in book-on-line for further clarification.

Terry
Go to Top of Page
   

- Advertisement -