What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?
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
Can group by be used without aggregate functions?
What are the 7 disadvantages to a manual system?
How do I start sql server agent automatically?
How to test a dml trigger in ms sql server?
How to get nth highest salary from employee table.
What is the difference between writing data to mirrored drives versus raid5 drives
How to set the current database in ms sql server?
How to find table changes in sql server?
How to execute multiple stored procedures at one time in sql server?
Can you leave a union at any time?
Does a server store data?
What is database replication?
What are the different types of sub-queries?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
Does partitioning ssd reduce performance?