一般这样的行旋转列称为旋转。但是你在这里指定的与它无关。



你需要一些更复杂的查询：

In general such rotation of rows to columns is called pivoting. But what you specified here has nothing to do with it.

You need a little bit more complex query:

select 
a.id, 
a.firstname, 
a.lastname, 
(select b.typename from table2 b where b.employeeid=a.id and b.typeid=1) as adminname  
(select b.typename from table2 b where b.employeeid=a.id and b.typeid=0) as employeename  
from table1 a