问题描述
表A
--------
EmployeeName EffectiveDate FieldType FieldValue
---------- - ------------- --------- ----------
Mg Mg 1/1/2010标题项目工程师
Mg Mg 1/1/2010部门IT部门
Mg Mg 1/1/2013标题辅助项目经理
Hla Kyaw 1 / 1/2012标题软件工程师
Hla Kyaw 2012年1月1日部门IT部门
如何为TableA编写select语句返回在TableB共振峰
TableB
------
EffectiveDate EmployeeName Title Department
---------- ---------- ----- -----------
1 / 1/2013 Mg Mg Assist项目经理IT部门
1/1/2012 Hla Kya w软件工程师IT部门
TableA
--------
EmployeeName EffectiveDate FieldType FieldValue
------------ ------------- --------- ----------
Mg Mg 1/1/2010 Title Project Engineer
Mg Mg 1/1/2010 Department IT Department
Mg Mg 1/1/2013 Title Assist Project Manager
Hla Kyaw 1/1/2012 Title Software Engineer
Hla Kyaw 1/1/2012 Department IT Department
How to write select statement for TableA to return in TableB formant
TableB
------
EffectiveDate EmployeeName Title Department
---------- ---------- ----- -----------
1/1/2013 Mg Mg Assist Project Manager IT Department
1/1/2012 Hla Kyaw Software Engineer IT Department
推荐答案
select EffectiveDate, EmployeeName, Title, Department from TableA where Department='IT Department'
这篇关于询问sql语句声明的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！