SQL查询中的aec和aer是什么？
我试图了解 aec 和 aer 在 SQL 查询中的作用
：
SELECT * FROM schema1.tablename1 aec
SELECT * FROM schema1.tablename2 aer
I'm trying to understand what does aec and aer do in a SQL Query
For ex:
SELECT * FROM schema1.tablename1 aec
SELECT * FROM schema1.tablename2 aer
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您可以看看“别名”概念： https://www.db2tutorial .com/db2-basics/db2-alias/
当您使用时（第二个查询也是如此）：
您实际上的意思是，从那里开始您将 schema1.tablename1 引用为“aec”，因此您可以执行以下操作：
You may have a look at the "alias" concept: https://www.db2tutorial.com/db2-basics/db2-alias/
When you use (and it's the same for the second query):
What you actually mean is that from there on you are referring to schema1.tablename1 as "aec", so you could do for example the following:
???? I Think, there is no particular sql query commands as "aec" and "aer"
from your code I can understand that query line:1
refers the tablename1 as "aec"; similar to "alias"
and same for the line:2
refers the tablename1 again with "aec"; similar to "alias"
???? Hope it helps, don't stop you own research until it satisfies you :)