Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

Answer Posted / ankita pandey

Equi Join -- Join performed in two tables having a common columna
with shared values in two tables by applying a where condition.
inner Join- Join performed in the same table itself(self join).

Is This Answer Correct ?    3 Yes 19 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain primary key?

945


What is resource governor in sql server?

973


Where is localdb stored?

921


What is the difference between Clustered and Non-Clustered Index?

1043


What is the data tier application?

169


what method you can use to reduce the overhead of Reporting Services data sources?

250


What is a document index?

1007


What does truncate do?

921


which table keeps the locking information? : Sql server administration

1044


What does it mean if @@cursor_row returns a negative number?

976


What are logical database components? : SQL Server Architecture

1010


Can we install sql server 2016 on windows 7?

1110


What are partitioned views?

966


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1238


What are the different types of subquery?

1131