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.
| Author |
Topic |
|
aidanh
Starting Member
1 Post |
 Posted - 2004-02-18 : 07:31:21
|
| Hi i'm trying to do something very simple, but I cant work out how.If I have two tables "a_t" and "b_t" both with colum "c_id"in table "b_t" I have colum "the_name"I add a colum "the_name" to "a_t"I now want to fill in colum "the_name" in "a_t" with the entries from "b_t". The tables are linked by "c_id". However there are no relationshow can I do this using TSQL?if anyone can help that would be great :)aidanh |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-18 : 08:18:57
|
| >> The tables are linked by "c_id". However there are no relationsNot sure what that means.Why do you want to do this?update a_tset the_name = b_t.the_namefrom a_tjoin b_ton b_t.c_id = a_t.c_id==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
TSQL beginner