如何缩短这个查询 [英] how can short this query

问题描述

我是sql查询的初学者



选择

EmployeeName.ID，EmployeeName.Ename，

Department.DepartmentName



来自

（Employee.Dept = Department.ID上的员工内部加入部门）

内连接Employee.ID上的EmployeeName = EmployeeName.ID;



我怎么能像这样写代码....



选择e.ename作为'名称'd.dname作为'dept-name'从emp-dpt作为e join emp作为e1在e.id = e.id加入dept作为d on d .did = e1.d.id



i认为两者都相同，但查询stlye是deffrent

i am beginner of sql query

select
EmployeeName.ID,EmployeeName.Ename,
Department.DepartmentName

from
(Employee inner join Department on Employee.Dept=Department.ID)
inner join EmployeeName on Employee.ID=EmployeeName.ID;

how can i write the code shortly like this....

select e.ename as 'name' d.dname as 'dept-name' from emp-dpt as e join emp as e1 on e.id = e.id join dept as d on d.did=e1.d.id

i think both are same but query stlye is deffrent

推荐答案

我认为你的意思是在查询中使用表别名。

尝试

http://www.w3schools.com/sql/sql_alias.asp [ ^ ]

http://www.tutorialspoint.com/sql/sql-alias-syntax.htm [ ^ ]

http://beginner-sql-tutorial.com/sql-aliases.htm [ ^ ]

I think you mean using table aliases in a query.
Try
http://www.w3schools.com/sql/sql_alias.asp[^]
http://www.tutorialspoint.com/sql/sql-alias-syntax.htm[^]
http://beginner-sql-tutorial.com/sql-aliases.htm[^]

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