<div>
<div class="content wysiwyg-content">
Please help, 
 
I have table emp 
 
ID &nbsp; NAME &nbsp; &nbsp; &nbsp; &nbsp;QUAL &nbsp; &nbsp; &nbsp; OJ 
1 &nbsp; &nbsp;JOHN &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 
2 &nbsp; &nbsp;DEREK &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 
3 &nbsp; &nbsp;SUE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 
4 &nbsp; &nbsp;JIM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 
5 &nbsp; &nbsp;DEAN &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03 &nbsp; &nbsp; &nbsp; &nbsp; 1 
6 &nbsp; &nbsp;SUZY &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01 &nbsp; &nbsp; &nbsp; &nbsp; 1 
7 &nbsp; &nbsp;RUTH &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02 &nbsp; &nbsp; &nbsp; &nbsp; 2 
&nbsp; 
I have table qual 
ID &nbsp; QUAL &nbsp; &nbsp; &nbsp;DESC 
1 &nbsp; &nbsp; &nbsp; &nbsp; 01 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DR 
2 &nbsp; &nbsp; &nbsp; &nbsp; 02 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MR 
3 &nbsp; &nbsp; &nbsp; &nbsp; 03 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VSS &nbsp; 
 
And I need to get table 
 
 
OJ &nbsp; DR &nbsp;MR VSS 
&nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; 1 &nbsp; 
&nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; 0 
 
I need how many DR, MR, VSS are in OJ 
 
 
P.S. I'm using SQL 2008 
Thank you very much 
&nbsp; &nbsp; 
</div>
</div>

Please help,

I have table emp

ID   NAME        QUAL       OJ
1    JOHN             01          1
2    DEREK          01          2
3    SUE                02          1
4    JIM                  02          2
5    DEAN              03         1
6    SUZY              01         1
7    RUTH              02         2
 
I have table qual
ID   QUAL      DESC
1         01             DR 
2         02             MR
3         03            VSS  

And I need to get table


OJ   DR  MR VSS
   1      2      1       1   
   2      1      2       0 

I need how many DR, MR, VSS are in OJ


P.S. I'm using SQL 2008
Thank you very much
    

INSERT INTO temp table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.