Answer Posted / sobia g.

An inner join is a join with a join condition that may contain both equality or non-equality sign whereas an equijoin is a join with a join condition that only contain only equality sign.
So we can say an equijoin is a type of inner join containing (Equal)= operator in the join condition.

It is good to know the difference between join and INNER JOIN keywoed. Actually there is no difference. If we write JOIN then by default INNER JOIN is performed. In the example it is also shown.
The following example will make you more clear.

In this example I used data as in example of Difference between Inner join and Outer join
SQL> select s.name,d.deptname from dept d, student s where d.deptid=s.deptid;
NAME DEPTNAME
--------------- ----------
Rafi CSE
Arju CSE

This example represents both INNER join and equijoin.
SQL> select s.name,d.deptname from dept d INNER JOIN student s on d.deptid=s.deptid;
NAME DEPTNAME
--------------- ----------
Rafi CSE
Arju CSE

Above example also represents both INNER join and equijoin.
SQL> select s.name,d.deptname from dept d INNER JOIN student s on d.deptid<>s.deptid;

NAME DEPTNAME
--------------- ----------
Rafi EEE
Raju EEE
Arju EEE
Raju CSE

Above example represents an inner join but not a equijoin.
SQL> select s.name,d.deptname from dept d JOIN student s on d.deptid<>s.deptid;

NAME DEPTNAME
--------------- ----------
Rafi EEE
Raju EEE
Arju EEE
Raju CSE

Above example show JOIN and INNER join keyword is same. If we don't specify INNER then by default inner join is performed.

What is conditional split?

996

---

Mention the different types of replication in sql server.

962

---

Difference between uniqe index and uniqe constraint?

918

---

Explain how you can deploy an SSRS report?

137

---

What is sqlservr.exe - process - sql server (sqlex?press)?

1059

---

Explain the third normal form(3nf)?

896

---

Define the one-to-one relationship while designing tables.

858

---

How to Update from select query in sql server?

997

---

List the data types available in mssql?

959

---

What are the different SQL Server Versions you have worked on?

953

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

956

---

Can sql server 2016 run on windows 7?

865

---

What is difference between sql and sql server?

939

---

Explain time data type in sal server 2008?

872

---

What are the differences between stored procedure and view in sql server?

1161

---