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 |
|
beedlesabout
Starting Member
1 Post |
 Posted - 2005-01-28 : 07:14:54
|
| I have a database which holds tables of which one is a code, the description to this is held in another database on same server.How do I extract the description to populate the code with description i.e. 0111 = testThanksSteve |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-01-28 : 07:51:33
|
| select t1.Description from Database1..table t1 , Database2..table t2 where t1.code=t2.codeMadhivanan |
 |
|
|
|
|
|
joing tables from two databases on same server