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
- 53241 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 blocking and how would you troubleshoot it? : sql server database administration
What is database dimension? : sql server analysis services, ssas
what is normalization? Explain different levels of normalization? : Sql server database administration
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is the Difference Between Primary and Foreign Key?
How can you find out how many rows returned in a cursor?
Explain Geography datatype in SQL Server
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Explain forward - only cursors?
What is indexed view? How to create it?
What are the properties of primary key?
How many tables can be joined in SQL Server?
What do you understand by mirroring and mention the advantages of the mirroring?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
