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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are types of scd? : sql server analysis services, ssas

726


How to create a view with data from multiple tables?

769


Which joins are sql server default?

683


You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

709


What is the difference between left and right outer join?

709






How to change a login name in ms sql server?

710


What new changes are being made in SQL Server?

776


What is difference between group by and having?

720


What are the differences between stored procedure and the dynamic sql?

762


What is the difference between clustered and non-clustered indexes in ms sql server?

673


when you create a database how is it stored? : Sql server database administration

679


What is order of B+tree?

859


What is a primary key?

695


What are the advantages of partitioning?

823


Where in ms sql server is ’100’ equal to ‘0’?

798