从子句中的SQL中的背面表引用是什么意思
我正在查看水晶报告中的查询,它显示一个表名称,后面紧跟着一个表名称。如果这没有意义,请参见下文,但我想了解这个语法是什么/做什么?预先感谢您的任何见解
select * from {oj ((table_name table_name inner join ......))}
I am looking at a query from crystal reports and it shows a table name immediately followed by a table name. see below if that didn't make sense but I am trying to understand what this syntax is/does? thank you in advance for any insight
select * from {oj ((table_name table_name inner join ......))}
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
第二个名字是别名。它允许您使用其他名称参考表。
例如,您可能需要在整个语句的其余部分中缩短对该表的引用,以使内容更可读。或者,更重要的是,您可能需要在同一语句中两次使用同一表(在这种情况下,需要别名)。
The 2nd name is the alias. It allows you to refer to the table using a different name.
For example, you may want to shorten the references to that table throughout the rest of the statement in order to make things more readable. Or, more importantly, you may want to use the same table twice in the same statement (in which case an alias is required).