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
52910 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

Is it possible to create trigger on views?

937

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2018

Write a SQL query to make a column as unique?

963

How to create a dynamic cursor with the dynamic option?

971

What are the essential components of sql server service broker?

966

What is policy based management (pbm)? : sql server database administration

931

Where are sql server usernames and passwords stored in the sql server?

1045

Explain candidate key, alternate key, and composite key?

942

How to optimize stored procedures in sql server?

1125

Determine when to use stored procedure to complete sql server tasks?

988

What is blocking?

984

In what sequence sql statement is processed?

957

What is the use of group by clause?

902

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

Explain what are the database objects? : SQL Server Architecture

1006