询问sql语句声明 [英] Asking about sql statement statement

问题描述

表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语句声明的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！