What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?
- 8 Answers
- 51842 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
What is difference between inner join and full join?
What do you understand by recursive stored procedure?
What is a field in a table?
What are “lock” hints?
What is xml datatype?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
How can you start sql server in different modes?
How do I find query history in sql server?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
How to get the definition of a trigger back?
Difference between group by clause and having clause in SQL?
What is an entity-relationship diagram (erd)?
What are the different types of columns types constraints in the sql server?
What is difference between cte and view?
Explain trigger and trigger types?
