[已解决]如何在三张桌子上加入？ [英] [Solved] How do I take join on three tables ?

问题描述

我在数据库中有三个表，这些是EMP_MASTER MBO_MASTER 和 REPORTING_MASTER，
 全部这些表 拥有 EMP_NO  一个公共字段，我希望 显示全部数据  EMP_MASTER   EMP_ID = '  4000004'  on  
基础  MBO_MASTER字段MBORQ_ID  等于   2    EMP_ID = '  4000004' 和其SUP_ID   '  12121212'   REPORTING_MASTER 

解决方案

试试这个：

 选择 * 来自 Emp_master   a  inner   join  MBO_master  as  b  on  a.emp_no = b.emp_no  inner   join  reporting_master  as  c  on   on  a.emp_no = c.emp_no 其中​​ a.EMP_ID = 4000004 和 b.MBORQ_ID = 2 和 c.sup_id = 12121212 

尝试：

  SELECT  
  FROM  Emp_Master e 
  JOIN  Mbo_Master m 
  ON  e.Emp_No = m.Emp_No 
  JOIN  Reporting_Master r 
  ON  e.Emp_No = r.Emp_No 
  WHERE  m.EBORQ_ID = 2  AND  e.EMP_ID = '  4000004'  AND  r.SUP_ID = '  12121212' 

I have three tables in the DB , These are EMP_MASTER MBO_MASTER and REPORTING_MASTER,
all these table having EMP_NO as a common field, I want to display all the data of EMP_MASTER for EMP_ID='4000004' on
the basis of MBO_MASTER field MBORQ_ID is equal to 2  for EMP_ID='4000004' and Whose SUP_ID is '12121212' in REPORTING_MASTER

解决方案

Try this:

select * from Emp_master as a inner join MBO_master as b on a.emp_no = b.emp_no inner join reporting_master as c on on a.emp_no = c.emp_no where a.EMP_ID=4000004 and b.MBORQ_ID =2 and c.sup_id =12121212

Try:

SELECT 
FROM Emp_Master e
JOIN Mbo_Master m 
    ON e.Emp_No=m.Emp_No
JOIN Reporting_Master r 
    ON e.Emp_No=r.Emp_No
WHERE m.EBORQ_ID=2 AND e.EMP_ID='4000004' AND r.SUP_ID='12121212'

这篇关于[已解决]如何在三张桌子上加入？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！