Get Value from another table

• sqlsdev

  SSC Veteran

  Points: 263

  More actions

  June 3, 2013 at 3:43 am

  #278129

  I have two tables, lets say Table 1 and Table 2 as below

  Table 1:

  Col1 Col2 Col3

  1 _A 11

  2 _B 12

  3 _C 12

  4 _A 11

  Table 2:

  ID Val

  _A A

  _B B

  _C C

  11 AA

  12 BB

  13 CC

  I need an output From Table1 and Table 2 as below

  1 A AA

  2 B BB

  3 C BB

  4 A AA

  I am very new to SQL Server. Can you please help me in getting this output?

  Thank you in advance

• HanShi

  SSC-Dedicated

  Points: 33506

  More actions

  June 3, 2013 at 4:03 am

  #1620449

  Duplicate post: http://www.sqlservercentral.com/Forums/Topic1459051-1292-1.aspx

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **