使用联接在SQL Server中联接4个表 [英] Joining 4 Tables in SQL Server Using Join

问题描述

朋友，我必须在SQL Server中加入4个表，并且需要在数据网格视图中显示特定的库尔姆斯

Hi Friends I have to join 4 tables in SQL Server and need to Show Specific Coulmns in Data Grid View

第一张表:emp_details

First Table : emp_details

第二张表:tbl_designation

Second Table : tbl_designation

第三张表:tbl_empcontribution

Third Table : tbl_empcontribution

第四张表:tbl_empdeduction

Forth table : tbl_empdeduction

需要在数据网格视图"中显示的列是

Columns need to show in Data Grid View is

1.从第一个表中，我需要显示emp_id，emp_name，emp_pf
2.从第二个表中，我需要显示designation_name
3.从第三张表我需要显示pfacc1和pfacc2
4.从第四张表我需要显示pf_percent和pf_max

1.From First Table i need to show emp_id, emp_name , emp_pf
2.from Second Table i need to show designation_name
3.from third Table i need to show pfacc1 and pfacc2
4.From Fourth Table i need to show pf_percent and pf_max

尝试尽快回复此好友...谢谢..

Try to Reply to this as soon as possible Friends...Thanks..

推荐答案

下面是您需要的查询，您应该考虑保持命名约定的一致性，因为这可以直观地帮助您并减少编写代码时的错误.

Below is the query you need, you should consider keeping your naming conventions consistent because this helps visually and reduce bugs when writing code.

SELECT ed.emp_id, ed.emp_name , ed.emp_pf, emd.designation_name, te.pfacc1, te.pfacc2, temp. pf_percent, temp.pf_max
FROM dbo.emp_details AS ed
LEFT JOIN dbo.emp_designation AS emd ON emd.designation_id = ed.emp_designation 
LEFT JOIN dbo.tbl_empcontribution AS te ON te.eid = ed.emp_id
LEFT JOIN dbo.tbl_empdeduction AS temp ON temp.eid = ed.emp_id

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