What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?
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 the architecture of ms sql reporting service?
What is cross join in sql server joins?
Explain Geography datatype in SQL Server
Explain query editor regions
how can you attach more than 20 ldf files in sql server
What is difference in performance between insert top (n) into table and using top with insert?
What is difference between foreign key and unique key?
What are the reporting services components?
What is the syntax for encrypting a column in SQL Server?
What is the full form of ddl?
What is sql injection? How to protect against sql injection attack?
What do you mean by acid?
What are joins in sql and what are the different types of joins?
What is order of B+tree?
role of sql sever 2005 in database rather than any other database