使用联接查询 [英] Query required using Joins

问题描述

我有两个表，提到的EQDUMP和HRISDetails为:-

EQDump表为:-

ECode	Ename
1	A
2	B
3	C
4	D

HRISDetails表格为:-

ECode	EName	managername
1	A	E
2	B	E
3	C	F
4	D	F
5	E	G
6	F	G

我需要一个查询，该查询为我提供了EqDump中的Empname字段，EQDUmp中的Ename字段和HRISDetails中的ManagerEmpID字段.
输出结果应如下所示:-

ECode	Ename	MCode
1	A	5
2	B	5
3	C	6
4	D	6

请向我提供查询(如果可能的话)，因为从事数据库方面工作的人员正在休假，而我只需要在紧急情况下写此即可:(

I have two table as mentioned EQDUMP and HRISDetails as:-

EQDump table as:-

ECode	Ename
1	A
2	B
3	C
4	D

HRISDetails Table as:-

ECode	EName	managername
1	A	E
2	B	E
3	C	F
4	D	F
5	E	G
6	F	G

I need a query which gives me the field Empname from EqDump,Ename from EQDUmp and ManagerEmpID from HRISDetails.
The Out put should be look like this:-

ECode	Ename	MCode
1	A	5
2	B	5
3	C	6
4	D	6

Please provide me the query if possible as the guys who are working on database side is on leave and i only have to write this on urgent basis:(

推荐答案

重复的帖子:

使用Joins查询从ManagerName中查找MCode [ ^ ]

duplicate post:

Query to find MCode from the ManagerName using Joins[^]

查询应为-

Query should be -

SELECT eq.ECode, eq.Ename, hri.ManagerEmpID 
FROM EQDump as eq 
INNER JOIN
HRISDetails as hri
ON eq.ECode = hri.ECode

但是在表中，您没有提到ManagerEmpID列.

But in table you did not mentioned the column ManagerEmpID.

select A.EmployeeName,A.Ecode,B.ECode as ManagerECode from HRISDetails as A inner join
HRISDetails as B on
A.ImmediateSupervisor=B.EmployeeName where A.Ecode in (Select SUBSTRING(ReporteeUserID,4,8) from EQDump)

<pre lang="SQL">

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