CrystalProgDev
Programmer
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
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