Inner join-returns only matching row with equality or nonequality sign e

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

Question Posted / aditya shukla

Answer Posted / aditya shukla

Inner join-returns only matching row with equality or nonequality sign

equijoin-this also return matching row but only equal sign

Is This Answer Correct ?

10 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are built in functions?

948

What is temporal table?

822

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

932

role of sql sever 2005 in database rather than any other database

1886

Can you please explain the difference between function and stored procedure?

958

what are constraints? : Sql server database administration

981

How many ways to create table-valued functions?

932

What is database dimension? : sql server analysis services, ssas

1030

What is report subscription?

117

How to write a query with a right outer join in ms sql server?

869

What is difference between commit and rollback when used in transactions?

902

Differentiate between a primary key and a unique key.

998

How can you set the threshold at which sql server will generate keysets asynchronously?

938

How to download and install microsoft .net framework version 2.0?

1101

Can we call future method from queueable?

991