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

Is oracle faster than sql server?

559


What are the types of subscriptions in SQL Server replication?

556


What is a sql join?

578


What is primary key index?

543


What is the use of partition by in sql server?

517






What is an indexing strategy?

542


Define constraints and give an example of their use?

566


Does sql server 2016 have ssms?

523


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

536


How to modify an existing user defined function?

605


What is database mirroring?

572


What is the index requirement in SQL Azure?

72


Can I run multiple instances of sql server 2000 at the same time on one computer?

610


How many clustered indexes there can be on table ?

610


What are cursors stored procedures and triggers?

527