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
- 53266 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / mobin sathupally
All are same.
Eg:
SELECT
*
FROM Emp INNER JOIN Emp1
ON eid=id
SELECT
*
FROM Emp EQUI JOIN Emp1
ON eid=id
SELECT
*
FROM Emp NATURAL JOIN Emp1
ON eid=id
| Is This Answer Correct ? | 18 Yes | 71 No |
Post New Answer View All Answers
Explain the different types of backups available in sql server? : sql server database administration
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
What is system stored procedures?
What is t-sql script to take database offline – take database online.
What is the purpose of forms?
What is the difference between local and global temporary tables?
What is the fillfactor concept in indexes?
What are subqueries in sql server? Explain its properties.
What are clustered and non-clustered index?
explain databases and sql server databases architecture? : Sql server database administration
Is sql server implemented as a service or an application? : Sql server database administration
Do you know what are the differences between lost updates and uncommitted dependencies?
How do I create a stored procedure in dbml?
How to Sync Two SQL Azure Databases?
What is a rownum?
