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

Answer Posted / samba shiva reddy . m

all are same but we can't use equi join and natural join in synax those are older

Is This Answer Correct ?    7 Yes 29 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the restrictions applicable while creating views? : SQL Server Architecture

752


What is difference between clustered index and non clustered index?

798


What do you understand by hotfixes and patches in sql server?

689


How do I save a stored procedure in sql server?

670


How to list all triggers in the database with sys.triggers in ms sql server?

751






How to delete duplicate rows from table except one?

708


What is the difference between char and varchar2 datatype in sql?

744


What is nonclustered index with included columns ?

712


Define left outer join?

756


How to create function without parameter in sql server?

738


How to loop through returning rows?

737


What will be query used to get the list of triggers in a database?

746


What are page splits?

762


How to modify the underlying query of an existing view?

748


Can you explain different types of locks in sql server?

709