请帮我解决我的SQL查询 [英] Please help me solve my SQL query

问题描述

select FileData,FileDataType, ComNo,ComCat,CompSubCat2,' <font color="#000000">' + Whom+ '<br>   <font color="#0099cc"> '+ HouseNo + '<br>'+Locality +'<br>  <font color="#000000">'+MobNo as name1,Complaint,Comment,grivtime,TimeStamp,action,EmployeeList.Name+'('+EmployeeList.Designation+')' as Forward_Name,comp_Solved.Name+'('+comp_Solved.Designation+')' as Officer, ActionFrom from comp_Solved left join EmployeeList on comp_Solved.[from] = EmployeeList.ID where  comNo='mcc/2016/7457' order by TimeStamp asc</font></font></font>

尊敬的先生，



这是我从查看comp_Solved的查询。列名'ActionFrom'int数据类型。在ActionFrom列中插入员工ID。我希望员工姓名而不是ActionFrom Id通过任何加入申请。



我尝试过：



i希望员工姓名而不是ActionFrom Id通过任何加入申请。

推荐答案

我将简化一点：

你有两个表：comp_solved和EmployeeList，你需要从comp_solved获取信息以及相关EmployeeList中的员工姓名。

所以首先尝试基础知识：

I'll simplify this a little:
You have two tables: comp_solved and EmployeeList and you need to get information from comp_solved plus the employee name from the related EmployeeList.
So try the basics first:

SELECT c.ComNo, e.EmployeeName 
FROM comp_solved c
JOIN EmployeeList e ON c.[From] = e.ID

运行它，你会得到每个与它相关的ComNo EmployeeName。



将其反馈到您的查询中，它应该是非常明显的wha你需要做什么

Run that, and you will get each ComNo with it's related EmployeeName.

Feed that back into your query, and it should be pretty obvious what you need to do

这篇关于请帮我解决我的SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！