All are same. Eg: SELECT * FROM Emp INNER JOIN Emp1 ON eid=id

What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?

Question Posted / mobin sathupally

8 Answers
53142 Views
Microsoft, I also Faced
E-Mail Answers

Answer Posted / mobin sathupally

All are same.

Eg:

SELECT
*
FROM Emp INNER JOIN Emp1
ON eid=id

SELECT
*
FROM Emp EQUI JOIN Emp1
ON eid=id

SELECT
*
FROM Emp NATURAL JOIN Emp1
ON eid=id

Is This Answer Correct ?

18 Yes

71 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Describe the left outer join & right outer join. : sql server database administration

985

What is a view and what are its advantages?

1095

How optimize sql query with multiple joins in sql server?

875

How to create a view with data from multiple tables?

997

What is the security principal at the server level that represents your session?

1000

How secure is sql server database?

988

How to return the second 5 rows in ms sql server?

1042

What is lock escalation and what is its purpose?

963

Tell me about joins in database system and explain each in detail.

1031

Write SQL queries on Self Join and Inner Join.

1129

How do I find my localdb version?

967

Define union, union all, minus, intersect?

961

Why I have to use stored procedures?

1018

What is nolock?

960

Explain about thread and memory management process of SQL?

957