joining columns in select - SQL Server Forums

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)

joining columns in select

Author

Topic

vinay789
Starting Member

40 Posts

Posted - 2009-05-06 : 07:50:02

Hi to everyone
i am a newbie to mssql my problem is in my db i have 2 queries like this
select t1,t2,t3 from T1 and another query select s1,s2,s3 from S1 now i want to add s1 field to T1 any suggestions pls

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-05-06 : 07:52:31

dup thread http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=125173

KH
[spoiler]Time is always against us[/spoiler]

greeny122229
Starting Member

25 Posts

Posted - 2009-05-06 : 08:50:41

Try

select
(select t1 from t1) + (select 's1' as y from s2)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources