joining colums to select statement in mssql

• bvinay57

  SSC Veteran

  Points: 224

  More actions

  May 6, 2009 at 5:38 am

  #384511

  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

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  May 6, 2009 at 8:03 am

  #989550

  I'm not really sure what you are asking, but it sounds like you need to learn how to use a JOIN. Start by reading this article:

  http://msdn.microsoft.com/en-us/library/ms191517.aspx

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question