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 / 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


Please Help Members By Posting Answers For Below Questions

Does full backup break log chain?

1013


What is the difference between push and pull subscription? : sql server replication

1274


What are the differences between stored procedure and view in sql server?

1312


What is read uncmmited?

1113


What are orphan records?

984


What is the order by used for?

1053


What are different types of roles provided by ssrs?

156


What are extended events in sql server?

1003


you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

1033


Mention what are the different types of ssrs reports?

158


List some advantages and disadvantages of stored procedure?

1063


What is hot add cpu in sql server 2008?

981


What do you mean by an execution plan? Why is it used?

1075


What is normalization? Explain different forms of normalization?

1225


What is pessimistic concurrency?

1021