What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?

Answer Posted / monal

INNER JOIN and EQUI-JOIN are same. Not sure about Natural
Join. Found answer in Books On Line.

Is This Answer Correct ?    29 Yes 51 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the data tier application?

159


Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

737


Explain the usage of floor function in sql server.

678


Can the “if update (colname)” statement be used in a delete trigger?

749


Explain a differential backup?

751






How to select all columns of all rows from a table with a select statement in ms sql server?

748


What command do we use to rename a db, a table and a column?

665


What is mean by candidate key?

747


How to create new table with "create table" statements?

728


How real and float literal values are rounded?

816


How can I tell if sql server is 32 or 64 bit?

707


Explain filestream storage of sql server 2008?

694


What is provisioning, billing and metering, and connection routing concepts in the service layer?

109


How to create a new schema in a database?

750


You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

113