What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?
- 8 Answers
- 51832 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
What is mean by dml?
What are the differences between stored procedure and view in sql server?
Mention the different types of replication in sql server.
What is isnull() operator?
What is an entity-relationship diagram (erd)?
What are the advantages of stored procedure in sql server?
What is a rownum?
What is data source view or dsv? : sql server analysis services, ssas
What are the fixed server level roles? : sql server security
What is normalization and what are the advantages of it?
Explain the relational database management system (rdbms)?
What are the recovery models in sql server 2000?
Detail about query optimizer?
Write a program using SQL queries to find a unique entry in a table.
How to check table values in sql server?
