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
- 53114 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 the maximum size of sql server database?
What are the types of joins in sql?
What is implicit mode in sql server?
Explain mixed authentication mode of sql server?
What is instead of trigger sql server?
what is spatial nonclustered index
What is partition, how will you implement it? : sql server analysis services, ssas
How do I open port 1433?
What is partitioned view?
Which command is used for user defined error messages?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Tell me about pre-defined functions of sql?
What are different types of raid levels?
What is service broker?
In which format does an image save in SQL Server database ?
