Sunday, June 2, 2013

[SQL Server] get lookup data

[SQL Server] get lookup data


get lookup data

Posted: 02 Jun 2013 01:15 PM PDT

I have two tables, lets say Table 1 and Table 2 as belowTable 1:Col1 Col2 1 _A2 _B3 14 2Table 2:ID Val_A A_B B_C C1 AA2 BB3 CCI need an output From Table1 and Table 2 as below1 _A A2 _B B3 1 AA4 2 BBI am very new to SQL Server. Can you please help me in getting this output?Thank you in advance

No comments:

Post a Comment

Search This Blog