What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?
- 8 Answers
- 50860 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 different types of relationships in the dbms?
Are connections to sql server encrypted?
What is exporting and importing utility?
How do you test your database? : sql server database administration
Why can there be only one clustered index and not more than one?
How does using a separate hard drive for several database objects improves performance right away?
what exactly sql injuction.how to overcome.....
Does order by actually change the order of the data in the tables or does it just change the output?
Do you know how to implement service broker?
Explain what are the events recorded in a transaction log?
What is coalesce in sql server?
Explain different backup plans?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
Explain about integration services of Microsoft SQL server?
What is nonclustered index with included columns ?
