Select multiple rows to columns in SQL server

Viewed 482

I want below output through SQL server.

TABLE A

| Id   |   Name   | 2016 | 2017 |  
 - - - - - - - - -  - - - - - - - 
| 1    |  ABCDEFG |      |      |
| 2    |  XYZLMON |      |      |

TABLE B

| Id   | Value | Year |  
 - - - - - - - - - - -
| 1    |  F    | 2016 |
| 1    |  G    | 2017 |

OUTPUT

| Id   |   Name   | 2016 | 2017 |  
 - - - - - - - - -  - - - - - - - 
| 1    |  ABCDEFG |  F   |  G   |
| 2    |  XYZLMON |      |      |
3 Answers
Related