在sqlserver中使用equi join和inner join [英] equi join and inner join in sqlserver

问题描述

equi join和inner join之间有什么区别。在内连接中，只会显示匹配的列，并且我们会使用operetor，但它是如何工作的。



提前致谢，

vani

Hi,

What is the difference between equi join and inner join. In inner join only matched columns will be displayed and equi join we use operetor but how it works.

Thanks in advance,
vani

推荐答案

Equi join使用等号作为比较运算符。内连接和外连接都属于equi连接。点击此处了解更多信息：



http：//初学者-sql-tutorial.com/sql-joins.htm [ ^ ]

Equi join uses equal sign as the comparison operator. Both inner join and outer join belong to equi join. Find out more here:

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

Peter Leow的解决方案1非常好，我会做一些额外的事情（添加链接）： SQL连接的可视化表示 [ ^ ]

Solution 1 by Peter Leow is very good and i would do something extra (add link): Visual Representation of SQL Joins[^]

这篇关于在sqlserver中使用equi join和inner join的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！