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
- 52902 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
How do I create a stored procedure in sql server?
What are the steps to process a single select statement?
What is service broker?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
How do clustered indexes store data?
How self join is different from outer join?
What are the differences between DDL, DML and DCL in SQL?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
Define Wed Edition in SQL Azure?
How to list all user defined functions in the current database?
What are the essential components of sql server service broker?
How to remove duplicate rows from table except one?
Create and insert into temp table in sql server?
What is meant by indexing files?
What are the kinds of subquery?
