SQL Server 2000 或 2005 中的联接
我试图了解 JOINS 在 SQL Server 2000 和 2005 上的工作方式具体。
一般来说，我了解内连接、左连接和右连接的工作原理。
然而，我读过的所有文章都用示例进行了解释，但并不特定于任何 RDBMS。所以现在我对不同类型的连接感到困惑，它们只是其他连接的同义词，实际上是不同的。
例如， LEFT OUTER JOIN 与 LEFT JOIN 相同吗？ RIGHT OUTER JOIN 与 RIGHT JOIN 相同吗？
SQL Server 是否支持FULL OUTER JOIN、CROSS JOIN？连接有哪些不同类型及其同义词。所有这些关键词都让我困惑。
I am trying to understand how JOINS work on SQL Server 2000 and 2005 SPECIFICALLY.
In general, I understand how inner joins, left joins and right joins work.
However, all the articles that I've read, explain it with examples, but are not specific to any RDBMS. So now I am confused to the different types of joins, which are just synonyms of other joins, and which are actually different.
For e.g.,
Is LEFT OUTER JOIN the same as LEFT JOIN?
Is RIGHT OUTER JOIN the same as RIGHT JOIN?
Does SQL Server support FULL OUTER JOIN, CROSS JOIN? What are the different types of joins, and their synonyms. All these keywords are confusing me.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
是的，SQL Server 支持
FULL OUTER JOIN和交叉连接。是的，
LEFT JOIN是LEFT OUTER JOIN的同义词。这同样适用于RIGHT JOIN。此外，
FULL JOIN也是FULL OUTER JOIN的同义词。您可能有兴趣查看 Jeff Atwood 撰写的以下文章：
Yes, SQL Server supports
FULL OUTER JOINandCROSS JOIN.And yes again,
LEFT JOINis a synonym forLEFT OUTER JOIN. The same applies toRIGHT JOIN.In addition,
FULL JOINis a also a synonym forFULL OUTER JOIN.You might be interested in checking out the following article by Jeff Atwood:
： MySQL 中 JOIN 和 OUTER JOIN 之间的差异
重复 右连接和右外连接之间没有区别，两者都是相同的。即左连接和左外连接都是相同的。
这会给你一个清晰的想法：
SQL 连接的可视化表示
Duplicate of : Difference between JOIN and OUTER JOIN in MySQL
There is no diffrence between Right Join and Right outer Join both are same. i.e Left Join and Left Outer Join both are same.
This will give you clear idea :
Visual Representation of SQL Joins