Query to Convert Rows to Columns in SQL Server

Hi

  I have 2 records like below .

I want Customer Data from Table 1 C001 & then its fields Emp_1,Emp_2  data from another table. Then for Customer C002 & then its fields Emp_1,Emp_2  data from another table.

using Sql Query

   Customer      Emp_1     Emp_2     Emp_3     Emp_4

      C001               E01         E02

      C002                E03        E04          E02

Thanks