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

How can you find out how many rows returned in a cursor?

551


Explain how dts is used to extract, transform and consolidate data?

582


What is exclusive locks?

537


Is it possible to have clustered index on separate drive from original table location?

515


Is sql server free?

526






How to disable triggers using "disable trigger"?

564


What is sql server locking?

553


wat wil hapn if we give the both read and deny read permission to user?

1656


How to insert new line characters into strings?

562


What is a non-clustered index?

566


Can sql servers link to other servers?

565


After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

570


Other than truncate statement, which other command can by-pass the trigger on the tables?

622


Why use “nolock” in sql server?

559


What does sql server mean?

538