In SqL, what is the difference between EQUI join and INNER join?
Share
Sign In to Kobiza.com to connect, share knowledge or learn
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
In Inner-join, only rows from joined tables are returned where a certain condition is met. This condition may be of equality, which means we would have an Equi-join. In the case the condition is not that of equality, it is called Nonequi-join.
In Inner-join, only rows from joined tables are returned where a certain condition is met. This condition may be of equality, which means we would have an Equi-join. In the case the condition is not that of equality, it is called Nonequi-join.