Interested to Buy Any Domain ? << Click Here >> for more details...
What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?
- 8 Answers
- 53506 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / sandy
Inner join can have equality (=) and other operators (like <,>,<>) in the join condition.
Equi join only have equality (=) operator in the join condition.
Equi join can be an Inner join, Left Outer join, Right Outer join
The USING clause is not supported by SQL Server and Sybase. This clause is supported by Oracle and MySQL.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Mention the command used to rename the database.
What is Sqlpaging in SqlServer 2005 ?
What are commit and rollback in sql?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is a trace frag? Where do we use it?
Describe the left outer join & right outer join. : sql server database administration
Explain about Views?
What is triggers in ms sql server?
What is the difference between a fill factor of 100 and 0?
Differentiate between a primary key and a unique key.
How to verify a user name with sqlcmd tool?
what are different types of raid configurations? : Sql server database administration
What does asynchronous call backs means?
What are the differences between decimal and float in ms sql server?
Explain what is lock escalation and what is its purpose?
