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 are various limitations of the views?

1055

---

Can primary key be a foreign key?

1058

---

Tell me what is the significance of null value and why should we avoid permitting null values?

985

---

How to use group functions in the select clause in ms sql server?

1054

---

Relational calculus is what type of language?

1036

---

Explain system rowset functions?

1003

---

Why are sql functions used?

1124

---

How do you use a subquery to find records that exist in one table and do not exist in another?

1049

---

How retrieve field names from the table in SQL through JAVA code?

1910

---

Define outer join in sql server joins?

936

---

Differentiate between ms sql server reporting services vs crystal reports?

905

---

What is the difference between char and varchar2 datatype in sql?

1066

---

What is the difference between rank and dense_rank?

1090

---

how many triggers you can have on a table? : Sql server database administration

976

---

List some of the rules that apply to creating and using a ‘view’

888

---