What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?
- 8 Answers
- 51838 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / ankita pandey
Equi Join -- Join performed in two tables having a common columna
with shared values in two tables by applying a where condition.
inner Join- Join performed in the same table itself(self join).
| Is This Answer Correct ? | 3 Yes | 19 No |
Post New Answer View All Answers
How to create a new schema in a database?
Is sql server a database?
How to provide column names in insert statements in ms sql server?
What is the purpose of forms?
What are the key configuration files for sql server reporting services ?
Do you know concepts and capabilities of sql server?
In which sql server version report builder introduced?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
what is the primary use of the model database? : Sql server administration
what is database replicaion? : Sql server database administration
What are the essential components of sql server service broker?
What are partitioned views?
What is the use of builtinadministrators group in sql server? : sql server security
Can one drop a column from a table?
In which format does an image save in SQL Server database ?
