如何在查询中不使用比较三个表 [英] how to use not in query to compare three tables

问题描述

如何在查询中不使用比较三个表



我在内连接中使用三个表但我不知道如何使用不在查询中比较三个表请帮帮我......



我的查询...

 选择 
 Employee.ID，Employee.Ecode，
 Manager.Mcode，
 EmployeeName.ID，EmployeeName .Ename 
 来自 
（经理加入员工 on  Manager.Mcode = Employee.Ecode）
  inner   join  EmployeeName   Employee.ID = EmployeeName.ID; 

这里我想不使用查询员工，员工姓名ID

解决方案

试试这个

 选择 
员工e.ID，Employee.Ecode，
 Manager.Mcode，
 EmployeeName.ID，EmployeeName.Ename 
 来自经理内部  join 员工  Manager.Mcode = Employee.Ecode 
 内部 加入员工姓名  Employee.ID = EmployeeName.ID 
 其中 Employee.ID  NOT   IN （ 1 ， 2 ， 3 ， 4 ， 5 ， 6 ， 7 ， 8 ， 9 ）; 

 选择 
雇员。 ID，Employee.Ecode，
 Manager.Mcode，
 EmployeeName.ID，EmployeeName.Ename 
  from  
 Manager < span class =code-keyword> right   join 员工  Manager.Mcode = Employee .Ecode 
  join  EmployeeName  on  Employee.ID = EmployeeName.ID  where  Manager.Mcode    null ; 

How to use not in query to compare three tables

hi , i am using three tables in inner join but i dont know how to use not in query in comparing three tables please help me......

my query...

select
Employee.ID,Employee.Ecode,
Manager.Mcode,
EmployeeName.ID,EmployeeName.Ename
from
(Manager  join Employee on Manager.Mcode=Employee.Ecode)
inner join EmployeeName on  Employee.ID=EmployeeName.ID;

here i want to use not in query for Employees, Employee Name ID's

解决方案

try this

select
Employee.ID,Employee.Ecode,
Manager.Mcode,
EmployeeName.ID,EmployeeName.Ename
from Manager  inner join Employee on Manager.Mcode=Employee.Ecode 
inner join EmployeeName on  Employee.ID=EmployeeName.ID
where Employee.ID NOT IN (1,2,3,4,5,6,7,8,9);

select
Employee.ID,Employee.Ecode,
Manager.Mcode,
EmployeeName.ID,EmployeeName.Ename
from
Manager  right join Employee on Manager.Mcode=Employee.Ecode
join EmployeeName on  Employee.ID=EmployeeName.ID where Manager.Mcode is null;

这篇关于如何在查询中不使用比较三个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！