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
 Transact-SQL (2000)
 Join Query

Author  Topic 

munishk
Starting Member

3 Posts

Posted - 2008-01-05 : 05:49:37
I have tab1 as:

Col1 Col2 Col3
1 2 Null

Then the Master tab2 as:

Col Name

1 One
2 Two
3 Three


I want the output as

Col1 Col2 Col3
One Two Null

Any help? I have been struggling since yesterday.I am using SQL Server 2000

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-01-05 : 07:02:22
I've answered it here:-

[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=95010[/url]
Go to Top of Page
   

- Advertisement -