hi guys i have problem to product a query in SQL Server.
I have a table with this records

```
+-------+--------------+------+
|field 1|field 2       |field3|
+-------+--------------+------+
|B395   |B.U. 2013     |1002  |
+-------+--------------+------+
|B395   |LOCATION 2013 |      |
+-------+--------------+------+
|B395   |MATERIALI 2013|3304  |
+-------+--------------+------+
|B395   |REVENUES 2013 |2202  |
+-------+--------------+------+
|B396   |B.U. 2013     |1002  |
+-------+--------------+------+
|B396   |LOCATION 2013 |      |
+-------+--------------+------+
|B396   |MATERIALI 2013|3304  |
+-------+--------------+------+
|B396   |REVENUES 2013 |2202  |
+-------+--------------+------+

```

i would like a query that return like this

```
+------+--------------+-------------+-------------------+------------------+
|Field1|field2        |field3       |field4             |field5            |
+------+--------------+-------------+-------------------+------------------+
|B395  |B.U. 2013 1002|LOCATION 2013|MATERIALI 2013 3304|REVENUES 2013 2202|
+------+--------------+-------------+-------------------+------------------+
|B396  |B.U. 2013 1002|LOCATION 2013|MATERIALI 2013 3304|REVENUES 2013 2202|
+------+--------------+-------------+-------------------+------------------+

```

i could do it with left join??

thanks a lot