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 the purposes and advantages stored procedure?

495


Do you know concepts and capabilities of sql server?

575


Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

490


How does using a separate hard drive for several database objects improves performance right away?

526


what are the Prerequisites for Replication?

10557






What is the difference between left and right outer join?

537


Can you roll back the ddl statement in a trigger?

518


can any body tell me how to know the password of current user in sql server

1573


What is meant by indexing files?

572


what is the information that can be stored inside a bit column? : Sql server database administration

514


What is the difference between for trigger and after trigger?

539


Can the “if update (colname)” statement be used in a delete trigger?

548


Do you know the capabilities of cursors?

530


How to restore performance issues and how to check?

1514


How to generate create procedure script on an existing stored procedure?

506