本文介绍了任何列的数据都将是另一个表的列名的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我在数据库中有2个表格，详细信息如下：
1）EmployeeDetailsTable
I have 2 tables in a data base and their details are given below:
1) EmployeeDetailsTable
empID|empName|empIncentives
001|xxx|2000
002|yyy|3000
2）EmployeeIncentiveTable
2) EmployeeIncentiveTable
empid|empIncentiveRcvMonth|status<
001|January|Received
002|January|Received
001|February|Received
002|February|Pending
001|March|Pending
002|March|Received
现在我必须创建一个类似的视图：
Now I have to create a view like:
empID|empName|January|Februaery|March
001|xxx|Received|Received|Pending
002|yyy|Received|Pending|Received
向我提供部署它的查询。
Provide me query to deploy it.
推荐答案
这篇关于任何列的数据都将是另一个表的列名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！